Overview of database object naming conventions

Each database object has a name. In SQL statements, you can use quoted identifiers or unquoted identifiers to represent the name of an object.

You can use quoted or unquoted identifiers to name any database object.

• Quoted identifiers are enclosed in double quotation marks ("). If you use quoted identifiers to name schema objects, you must use double quotation marks when referencing the object.

• Unquoted identifiers are not enclosed in any punctuation marks.

However, database names, global database names, and database link names are always case-insensitive and stored in uppercase. If you specify such names as quoted identifiers, the quotation marks are silently ignored. For information about user naming, see CREATE USER.