RE: escape column name
- From: "Ron Rogers" <RROGERS@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 15 Apr 2004 09:38:12 -0400
Randy,
Would it be easier to RENAME the column and then create the view?
Ron
>>> RASTEIN@xxxxxxxx 04/15/2004 9:25:50 AM >>>
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 //www.freelists.org/archives/oracle-l/
FAQ is at //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 //www.freelists.org/archives/oracle-l/
FAQ is at //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 //www.freelists.org/archives/oracle-l/
FAQ is at //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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
