Naming Convention of Tables and Columns

Oracle database tables and columns naming follow some standard rules. Those rules are explained in this page:

Name starts with a letter:

All table names and column names start with a letter. The name must be 1-30 characters long.

Allowable characters for naming:

The follwoing charactesr are allowed to name any table or column-

• characters: A-Z
  
• characters: a-z
  
• characters: 0-9
  
• characters: _ [underscore]
  
• characters: $
  
• characters: #
  

No duplication:

Names must not duplicate any other object's name of the same user.

No reserved word:

Oracle server reserved word must not be  the name of tables or columns.

Note:

Names aren't case sensitive. For example, STUDENTS is same as students or sTuDeNtS or STUdents etc.