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