SQL$HELP72.HLB  —  CREATE  COLLATING_SEQUENCE, Example
    Example 1: Creating a French collating sequence

    The following example creates a collating sequence using
    the predefined collating sequence FRENCH. It then shows the
    defined collating sequence by using the SHOW COLLATING SEQUENCE
    statement.

    SQL> CREATE COLLATING SEQUENCE FRENCH FRENCH;
    SQL> --
    SQL> SHOW COLLATING SEQUENCE
    User collating sequences in schema with filename SQL$DATABASE
         FRENCH

    Example 2: Create a Spanish collating sequence specifying more
    than one comment

    SQL> CREATE COLLATING SEQUENCE SPANISH_COL
    cont> COMMENT IS 'first comment' / 'second comment'
    cont> SPANISH;
    SQL> SHOW COLLATING SEQUENCE SPANISH_COL;
         SPANISH_COL
     Comment:       first comment
                    second comment
Close Help