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. |