Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: escape column name

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US