Collation functions

The following table describes the supported collation functions.

Function	Description
COLLATION	Returns the name of the derived collation for expr. Produces named collations and pseudo-collations; for Unicode Collation Algorithm (UCA) collations, returns the long form of the name. Evaluated at SQL compilation. Returns NULL if the derived collation is undefined because of a collation conflict.
NLS_COLLATION_ID	Returns the collation ID number for a given collation name. Collation IDs are used in data dictionary tables and Oracle Call Interface (OCI), while collation names are used in SQL statements and data dictionary views.
NLS_COLLATION_NAME	Returns the collation name for a given collation ID number. Collation IDs are used in data dictionary tables and Oracle Call Interface (OCI), while collation names are used in SQL statements and data dictionary views.