RE: sql and oracle reserved words

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Thu, 25 May 2006 15:04:49 -0400
Message-ID: <KNEIIDHFLNJDHOOCFCDKCEALICAA.mwf@rsiz.com>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Joe Smith
Sent: Thursday, May 25, 2006 2:28 PM
To: oracle-l_at_freelists.org
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

Received on Thu May 25 2006 - 14:04:49 CDT