Home » Other » General » Oracle keyword as table name (merged)
Oracle keyword as table name (merged) [message #162973] Tue, 14 March 2006 06:47 Go to next message
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 Go to previous messageGo to next message
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: Using Oracle Keyword as table name [message #162978 is a reply to message #162973] Tue, 14 March 2006 06:54 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> 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.

you are still in development. It is better to change now!.
Right now, i dont have any exact scenario/problem you might face later.
Re: Oracle Keyword as table name [message #163286 is a reply to message #162975] Wed, 15 March 2006 23:36 Go to previous message
Frank Naude
Messages: 4579
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.

Previous Topic: ASM filesystem
Next Topic: Can we use solaris commands in pl/sql procedure ?
Goto Forum:
  


Current Time: Fri Mar 29 05:02:53 CDT 2024