Oracle Collation Functions

The collation functions return information about collation settings. This page summarizes collation functions in Oracle.

  1. COLLATION

    Oracle COLLATION() is a built-in function that returns the name of the derived collation for a given expression.

  2. NLS_COLLATION_ID

    Oracle NLS_COLLATION_ID() is a built-in function that returns the corresponding collation ID number based on the given collation name.

  3. NLS_COLLATION_NAME

    Oracle NLS_COLLATION_NAME() is a built-in function that returns the corresponding collation name based on the given collation ID.