RE: escape column name

Maybe I don't understand the problem correctly, but this is what I think the problem is: The "&" is considered as a special character, the "DEFINE" character, NOT the ESCAPE character. (e.g. the character used for define variables as seen in the example below). But this should only happen in SQL*Plus. Why do you think the report writer would have the same problem? SQL> select '&x' from dual ;
Entrez une valeur pour x : ABC
ancien 1 : select '&x' from dual
nouveau 1 : select 'ABC' from dual
'AB

---
ABC
SQL> define x = "HELLO"
SQL> select '&x' from dual ;
ancien   1 : select '&x' from dual
nouveau   1 : select 'HELLO' from dual
'HELL
-----
HELLO
SQL> set define off
SQL> select '&x' from dual ;
'&
--
&x



> -----Original Message-----

> Steiner, Randy

>


> 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.

>


>  -----Original Message-----

> From:         Venkatesh Sadagopan

>


> 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-----

>


> 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"




----------------------------------------------------------------
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
-----------------------------------------------------------------