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@(protected)
Behalf Of Joe Smith
Sent: Thursday, May 25, 2006 2:28 PM
To: oracle-l@(protected)
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/

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l