Oracle functions are built into Oracle and are available for use in various appropriate Oracle statements. You can also create your own function using PL/SQL.
Function | Description |
---|---|
BIN_TO_NUM | Converts a bit vector to a number. |
CAST | Converts one datatype to another. |
CHARTOROWID | Converts a char, varchar2, nchar, or nvarchar2 to a rowid. |
FROM_TZ | Converts a TIMESTAMP value to a TIMESTAMP WITH TIME ZONE value. |
HEXTORAW | Converts a hexadecimal value into a raw value. |
NUMTODSINTERVAL | Converts a number to an INTERVAL DAY TO SECOND literal. |
NUMTOYMINTERVAL | Converts a number to an INTERVAL YEAR TO MONTH literal. |
RAWTOHEX | Converts a raw value into a hexadecimal value. |
TO_CHAR | Converts a number or date to a string. |
TO_CLOB | Converts a LOB value from the national character set to the database character set. |
TO_DATE | Converts a string to a date. |
TO_DSINTERVAL | Converts a string to an INTERVAL DAY TO SECOND type. |
TO_LOB | Converts LONG or LONG RAW values to LOB values. |
TO_MULTI_BYTE | Returns a character value with all of the single-byte characters converted to multibyte characters. |
TO_NCLOB | Converts a LOB value to a |
TO_NUMBER | Converts a string to a number. |
TO_SINGLE_BYTE | Returns a character value with all of the multibyte characters converted to single-byte characters. |
TO_TIMESTAMP | Converts a string to a timestamp. |
TO_TIMESTAMP_TZ | Converts a string to a timestamp with time zone. |
TO_YMINTERVAL | Converts a string to an INTERVAL YEAR TO MONTH type. |