Default Naming of a Pre-26ai Collection Table
For pre-26ai collections, the name of the table that backs a collection is derived from the collection name as follows (if you want a different table name from the default one, then use custom collection metadata to specify it).
-
Each ASCII control character and double quotation mark character (
") in the collection name is replaced by an underscore character (_). -
If all of the following conditions apply, then all letters in the name are converted to uppercase, to provide the table name. In this case, you need not quote the table name in SQL code; otherwise, you must quote it.
-
The letters in the name are either all lowercase or all uppercase.
-
The name begins with an ASCII letter.
-
Each character in the name is alphanumeric ASCII, an underscore (
_), a dollar sign ($), or a number sign (#).Note: Oracle recommends that you do not use dollar-sign characters (
$) or number-sign characters (#) in Oracle identifier names.
-
For example:
-
Collection names “col” and “COL” both result in a table named “COL”. When used in SQL, the table name is interpreted case-insensitively, so it need not be enclosed in double quotation marks (
"). -
Collection name “myCol” results in a table named “myCol”. When used in SQL, the table name is interpreted case-sensitively, so it must be enclosed in double quotation marks (
").
Related Topics