Oracle Conversion Functions

Oracle ASCIISTR() is a built-in function that returns the ASCII version of a given string in the database character set.

Oracle BIN_TO_NUM() is a built-in function that returns the number converted from the bit vector specified by the arguments.

Oracle CAST() is a built-in function that converts a given argument from one type to another. This function supports both basic data types and collection types.

Oracle CHARTOROWID() is a built-in function that converts a given string value to the ROWID data type.

Oracle COMPOSE() is a built-in function that returns the result of applying Unicode normalization (as described in Unicode Standard Definition D117) to the given string parameter.

Oracle CONVERT() is a built-in function that converts a given string from one character set to another.

Oracle DECOMPOSE() is a built-in function that returns the result of applying a Unicode decomposition to the given argument.

Oracle HEXTORAW() is a built-in function that converts a hexadecimal value specified as a parameter into a raw value.

Oracle NUMTODSINTERVAL() is a built-in function that converts a given number to text in INTERVAL DAY TO SECOND format.

Oracle NUMTOYMINTERVAL() is a built-in function that converts a given number to INTERVAL YEAR TO MONTH text.

Oracle RAWTOHEX() is a built-in function that converts a raw value to a character value that contains its hexadecimal representation.

Oracle RAWTONHEX() is a built-in function that converts a raw value to a character value containing its hexadecimal representation.

Oracle ROWIDTOCHAR() is a built-in function that converts a given rowid value to VARCHAR2 type.

Oracle ROWIDTONCHAR() is a built-in function that converts a given rowid value to the VARCHAR2 data type.

Oracle SCN_TO_TIMESTAMP() is a built-in function that returns an approximate timestamp associated with a given system change number (SCN).

Oracle TIMESTAMP_TO_SCN() is a built-in function that returns an approximate system change number (SCN) associated with a given timestamp.

Oracle TO_BINARY_DOUBLE() is a built-in function that converts the given expression to a double precision floating point number.

Oracle TO_BINARY_FLOAT() is a built-in function that converts the given expression to a binary float.

Oracle TO_BLOB(bfile) is a built-in function that converts a BFILE value to a BLOB value.

Oracle TO_BLOB(raw) is a built-in function that converts a given LONG RAW and RAW value to a BLOB value.

Oracle TO_CHAR(bfile|blob) is a built-in function that converts BFILE or BLOB data into the database character set.

Oracle TO_CHAR(character) is a built-in function that converts NCHAR, NVARCHAR2, CLOB, or NCLOB data to the database character set.

Oracle TO_CHAR(datetime) is a built-in function that converts a given date, time, or interval value to a string based on a specified format.

Oracle TO_CHAR(number) is a built-in function that converts a given numeric value to a value of the VARCHAR2 data type using an optional format parameter.

Oracle TO_CLOB(bfile|blob) is a built-in function that converts BFILE or BLOB data to the database character set and returns the data as a CLOB value.

Oracle TO_CLOB(character) is a built-in function that is used to convert NCLOB values or other character strings in LOB columns to CLOB values.

Oracle TO_DATE() is a built-in function that converts a given string date to a value of the DATE data type according to an optional format.

Oracle’s TO_DSINTERVAL() is a built-in function that converts a given string parameter into a INTERVAL DAY TO SECOND type value.

Oracle TO_LOB() is a built-in function that converts LONG or LONG RAW values in a given column to LOB values. You can only apply this function to LONG or LONG RAW columns and only in the select list of a subquery in an INSERT statement.

Oracle TO_MULTI_BYTE() is a built-in function that converts all single-byte characters in the given parameter to their corresponding multi-byte characters and returns a value of the same data type as the parameter.

Oracle TO_NCHAR(character) is a built-in function that converts NCHAR, NVARCHAR2, CLOB, or NCLOB data to the national character set.

Oracle TO_NCHAR(datetime) is a built-in function that converts the given date, time, or interval value to a string according to the specified format.

Oracle TO_NCHAR(number) is a built-in function that converts the given numeric value to a value of VARCHAR2 data type using an optional format parameter.

Oracle TO_NCLOB() is a built-in function that converts a CLOB value in a LOB column or other character string to an NCLOB value.

Oracle TO_NUMBER() is a built-in function that converts the given argument to a value of data type NUMBER.

Oracle TO_SINGLE_BYTE() is a built-in function that converts all multi-byte characters in the given argument to their corresponding single-byte characters and returns a value of the same data type as the argument.

Oracle TO_TIMESTAMP() is a built-in function that converts a given string parameter to a value of type TIMESTAMP.

Oracle TO_TIMESTAMP_TZ() is a built-in function that converts the given string argument to a TIMESTAMP WITH TIME ZONE data type.

Oracle TO_YMINTERVAL() is a built-in function that converts a given string parameter to a value of type INTERVAL MONTH TO YEAR.

Oracle TREAT() is a built-in function used to change the declared type of an expression.

Oracle UNISTR() is a built-in function that returns the given character data in the national character set.

Oracle VALIDATE_CONVERSION() is a built-in function that is used to determine whether a given expression can be converted to a given data type.