RE: escape column name

From: Venkatesh Sadagopan <Venkatesh.Sadagopan_at_veritas.com>
Date: Wed, 14 Apr 2004 14:47:01 -0700
Message-ID: <414E78DD05C7D411A0200008C786261808E0A22E@mtvxch13.veritas.com>

Did you try to set escape off and tried it..

In sqlplus

       set escape off
        and then run your query..

or alternatively you can set escape character to something else other than &..

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

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]
Sent: Wednesday, April 14, 2004 2: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:45:38 CDT