OraFAQ Forum: SQL & PL/SQL » Re: Can we use PL/SQL key words as Coloumn Names

Home » SQL & PL/SQL » SQL & PL/SQL » Re: Can we use PL/SQL key words as Coloumn Names

Fri, 31 May 2002 09:17

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');

Fri, 07 June 2002 03:44

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: Thu Apr 25 22:03:02 CDT 2024