Thursday, December 29, 2016

Naming Rules: in oracle dbms

Naming Rules:

-----------------------------------------------

1. Each name should begun with alphabetic character.

2. Void character set is a-z, A-Z, 0-9, @, #, $, _ used but first name should be a letter.

3. Names are not case sensitive.

4. Spaces not allowed within the name.

5. Duplicate names are not allowed.

6. Reserved words not allowed as names.

7. Maximum length of a name is 30 character length.

EX:

 Valid   | Invalid
emp_dtls   | emp-dtls
emp123   | 123emp
pdod#info | prod.detls
table123   |      table
--------------------------

No comments:

Post a Comment