In Oracle Database, the COALESCE() function returns the first non-null expression the expression list.
Tag: what is
ROWIDTONCHAR() Function in Oracle
In Oracle Database, the ROWIDTONCHAR() function converts a ROWID value to NVARCHAR2 data type
It’s similar to the ROWIDTOCHAR() function, except that ROWIDTOCHAR() converts a ROWID value to VARCHAR2 data type.
ROWIDTOCHAR() Function in Oracle
In Oracle Database, the ROWIDTOCHAR() function converts a ROWID value to VARCHAR2 data type.
CHARTOROWID() Function in Oracle
In Oracle Database, the CHARTOROWID() function converts a string value to ROWID data type.
TO_DATE() Function in Oracle
In Oracle Database, the TO_DATE() function converts its argument to a value of DATE data type.
RAWTONHEX() Function in Oracle
In Oracle Database, the RAWTONHEX() function converts a raw value to hexadecimal.
It’s similar to the RAWTOHEX() function, except that its value is always returned in the national character set.
RAWTOHEX() Function in Oracle
In Oracle Database, the RAWTOHEX() function converts a raw value to hexadecimal.
HEXTORAW() Function in Oracle
In Oracle Database, the HEXTORAW() function converts hexadecimal to a raw value.
DECOMPOSE() Function in Oracle
In Oracle Database, the DECOMPOSE() function returns the result of applying one of the Unicode decompositions to its string argument. The decomposition is determined by the second (optional) argument.
It’s the opposite of the COMPOSE() function.
COMPOSE() Function in Oracle
In Oracle Database, the COMPOSE() function returns the result of applying the Unicode canonical composition, as described in the Unicode Standard definition D117, to its string argument.
It’s the opposite of the DECOMPOSE() function.