RE: escape column name

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Thu, 15 Apr 2004 09:38:12 -0400
Message-Id: <s07e5821.095@galottery.org>

Randy,
 Would it be easier to RENAME the column and then create the view? Ron

>>> RASTEIN_at_NYCT.com 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_at_veritas.com] 
Sent:	Wednesday, April 14, 2004 5:47 PM
To:	'oracle-l_at_freelists.org'
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_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 


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

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

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 Thu Apr 15 2004 - 08:38:03 CDT