Home » RDBMS Server » Server Administration » Reserved words, Special Characters, etc.
Reserved words, Special Characters, etc. [message #62451] Thu, 22 July 2004 10:42 Go to next message
ray1234321
Messages: 1
Registered: July 2004
Junior Member
Where can I find a simple list of Oracle naming limitations: what are the reserved words, what are name length limitations for tables and columns, what special characters can not be used?  Oracle seems to hide this documentation on their website, which is quite frustrating.  They are starting to look like SQL Server!

Ray
Re: Reserved words, Special Characters, etc. [message #62452 is a reply to message #62451] Thu, 22 July 2004 12:33 Go to previous messageGo to next message
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
Senior Member
See Appendix F in the Oracle Doc

or just follow the link (OTN you need login id)

http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96624/f_words.htm#14267
Re: Reserved words, Special Characters, etc. [message #62464 is a reply to message #62451] Fri, 23 July 2004 00:45 Go to previous message
Frank Naude
Messages: 4587
Registered: April 1998
Senior Member
Hi,

You can also get a list of reserved words by querying the following table:

SQL> select * from v$reserved_words;

KEYWORD                            LENGTH
------------------------------ ----------
MODE                                    4
BULK                                    4
WAIT                                    4
SESSIONTIMEZONE                        15
EXTENTS                                 7
SESSION_CACHED_CURSORS                 22
SET_TO_JOIN                            11
PUSH_SUBQ                               9
OID                                     3
START                                   5
ROLE                                    4
...


BTW: All Oracle products ship with generic documentation CDs and platform specific documentation on the installation CDs. Maybe you should just go and dig them out.

Best regards.

Frank
Previous Topic: TEXT_IO_FILE
Next Topic: Oracle shared pool
Goto Forum:
  


Current Time: Thu Jan 09 04:15:04 CST 2025