RE: escape column name

I need to put these columns into a view and the pass the view to a report
writer, so set escape off may not help.

Randy

 -----Original Message-----
From:   Venkatesh Sadagopan [mailto:Venkatesh.Sadagopan@xxxxxxxxxxx] 
Sent:   Wednesday, April 14, 2004 5:47 PM
To:     'oracle-l@xxxxxxxxxxxxx'
Subject:        RE: escape column name

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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
Sent: Wednesday, April 14, 2004 2:36 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts: