Use of Uppercase Characters

You can specify the name of a database object with uppercase characters, but the database server shifts these to lowercase characters unless the DELIMIDENT environment variable is set and the identifier of the database object is enclosed between double ( " ) quotation marks. In this case, the database server treats the name of the database object as a delimited identifier and preserves the uppercase characters in the name, as described in Delimited Identifiers.

If the name of a database server includes uppercase letters, that database server cannot participate in distributed DML operations. To avoid this restriction, use only undelimited names that include no uppercase letters when you declare the name or the alias of a database server.


Copyright© 2019 HCL Technologies Limited