Reserved words, Special Characters, etc. [message #62451] |
Thu, 22 July 2004 10:42 |
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 #62464 is a reply to message #62451] |
Fri, 23 July 2004 00:45 |
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
|
|
|