Oracle 9i Tutorial : Naming Rule

Naming Rules :

Table names and column names:
  1. Must begin with a letter
  2. Must be 1–30 characters long
  3. Must contain only A–Z, a–z, 0–9, _, $, and #
  4. Must not duplicate the name of another object owned by the same user
  5. Must not be an Oracle server reserved word

 Naming Guidelines

Use descriptive names for tables and other database objects.
Note: Names are case insensitive. For example, EMPLOYEES is treated as the same name as eMPloyees or eMpLOYEES.
For more information, see Oracle9i SQL Reference,“Object Names and Qualifiers.”

Leave a Reply