Oracle SQL Create Table Naming Rules

Rules to follow before writing names (Object names, Column Names and Variable Names).    

1.    Name should begin with alphabet.

2.    within the name we can use the below characters.                                              

    a-z, A-Z, 0-9, @, $, # and _ (under score)                                                                    

Ex:       Emp123                                                                                   

            Emp_o11                                                                                 

3.    Names are not case sensitive.                                                                                        

            Emp/emp/EMP all are same.                                                                            

4.    Duplicate names are not allowed.                                                                                  

·       Within a table don't use duplicate column names.                                              

·       Within user account, don’t use duplicate table names.

·       Within a program, don't use duplicate variable names.

5.    Don't use commands or keywords as table names or column names.

6.    spaces are not allowed with in a name.

Min length of name is 1 char and Max length of name is 30 chars.

Valid_Names	Invalid_Names
Emp_info	Emp info  Since blank space with in the name
emp@sal	emp.sal    Since " . " is not valid character
emp123	123emp Since Name is not beginning with alphabet
emp_info	emp-info  Since " -" is not valid char.
emp_table	Table  Since " table " is a reserved word