RE: escape column name

From: Goulet, Dick <DGoulet_at_vicr.com>
Date: Wed, 14 Apr 2004 17:45:01 -0400
Message-ID: <4001DEAF7DF9BD498B58B45051FBEA656D83C7@25exch1.vicorpower.vicr.com>

"Set define off" or "set define <to something else>". After that, find = the duhveloper who defined that table & shoot them. You'll be doing the = rest of us a favor.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----

From: Steiner, Randy [mailto:RASTEIN_at_NYCT.com] Sent: Wednesday, April 14, 2004 5:36 PM
To: oracle-l_at_freelists.org
Subject: escape column name

I inherited a db with column names like: Close Date & Time

I am having trouble querying these columns. When I put double quotes = around
them, I get:

Enter value for time: old 17: ,"Close Date & Time"

Any help appreciated.

Randy

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Wed Apr 14 2004 - 16:43:35 CDT