Which has the higher priority in your organization: Deploying a new database or securing the ones you already have?
Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Be sure to view the full listing of monographs in Morgan's Library
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;