Home » SQL & PL/SQL » SQL & PL/SQL » Re: Can we use PL/SQL key words as Coloumn Names
Re: Can we use PL/SQL key words as Coloumn Names [message #38971] Fri, 31 May 2002 09:17 Go to next message
billh
Messages: 35
Registered: August 1999
Member
Try enclosing the column name NOT in double quotes.

INSERT into EMP(emp_name,emp_id,"not",emp_designation) values('xxx',001,'problem','manager');
Re: Can we use PL/SQL key words as Coloumn Names [message #39023 is a reply to message #38971] Fri, 07 June 2002 03:44 Go to previous message
Balaji
Messages: 102
Registered: October 2000
Senior Member
I recommend not to use any oracle keywords for naming a object. sometimes they work and sometimes they wont.

balaji
Previous Topic: Date Format Conversion
Next Topic: SQL Variables?
Goto Forum:
  


Current Time: Fri Nov 16 03:36:47 CST 2018