RE: sql and oracle reserved words
- From: "Mark W. Farnham" <mwf@xxxxxxxx>
- To: <joe_dba@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 25 May 2006 15:04:49 -0400
Try select "COMMENT" from table_name;
If the column name is actually lower case, then
select "comment" from table_name;
mwf
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of Joe Smith
Sent: Thursday, May 25, 2006 2:28 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: sql and oracle reserved words
List,
I have a person trying to run a query with a reserved word. They are trying
to access a sybase db thru oracle with a query like
>select comment from table_name;
Is there a way to escape a reserved word in sql like that?
thanks.
_________________________________________________________________
FREE pop-up blocking with the new MSN Toolbar - get it now!
http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
