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