ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located in North America that send an email to
email@example.com. Request a Workshop for
your organization today.
These functions return collation setting information.
Have you seen the Functions page? If not ... Click Here ... for information on all Oracle functions
Returns the name of the derived collation named collations and pseudo-collations.
If the derived collation is a Unicode Collation Algorithm (UCA) collation, then the function returns the long form of its name. If the derived collation is undefined due to a collation conflict returns NULL.
COLLATION(<expression>) RETURN VARCHAR2;
SQL> CREATE TABLE id_table (
2 coll_name VARCHAR2(64) COLLATE BINARY_AI,
3 coll_id VARCHAR2(8) COLLATE BINARY_CI);
CREATE TABLE id_table (
ERROR at line 1:
ORA-43929: Collation cannot be specified if parameter MAX_STRING_SIZE=STANDARD is set.
ALTER SYSTEM SET max_string_size=extended COMMENT='Collation enabled 15-Mar-2018' SID='*' SCOPE=SPFILE;