| Oracle keyword as table name (merged) [message #162973] |
Tue, 14 March 2006 06:47  |
ssk8181
Messages: 6
Registered: February 2006
Location: Chennai
|
Junior Member |
|
|
Hi,
In our application database we have a table name as ROLE.
As this is an oracle keyword, I doubt whether this is will create any problem in the future.
We are more than half way through the development and there will be a lot of rework if we need to change now at this point of time. Please give suggestion is that table name must be changed to a non-keyword.
Regards,
Senthil.
|
|
|
|
| Oracle Keyword as table name [message #162975 is a reply to message #162973] |
Tue, 14 March 2006 06:50  |
ssk8181
Messages: 6
Registered: February 2006
Location: Chennai
|
Junior Member |
|
|
Hi,
In our application database we have a table name as ROLE.
As this is an oracle keyword, I doubt whether this is will create any problem in the future.
We are more than half way through the development and there will be a lot of rework if we need to change now at this point of time. Please give suggestion is that table name must be changed to a non-keyword.
Regards,
Senthil.
|
|
|
|
|
|
| Re: Oracle Keyword as table name [message #163286 is a reply to message #162975] |
Wed, 15 March 2006 23:36 |
Frank Naude
Messages: 4581
Registered: April 1998
|
Senior Member |
|
|
ROLE is a keyword, however, its NOT a reserved word. Proof - reserved=N in the query below:
SQL> DESC v$reserved_words
Name Null? Type
----------------------------------------- -------- ----------------------------
KEYWORD VARCHAR2(30)
LENGTH NUMBER
RESERVED VARCHAR2(1)
RES_TYPE VARCHAR2(1)
RES_ATTR VARCHAR2(1)
RES_SEMI VARCHAR2(1)
DUPLICATE VARCHAR2(1)
SQL> SELECT * FROM v$reserved_words WHERE keyword = 'ROLE';
KEYWORD LENGTH R R R R D
------------------------------ ---------- - - - - -
ROLE 4 N N N N N
CREATE TABLE role (col1 DATE);
Table created.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
