Re: strange sql command

Hi,

set escape |
select 'test 123|&1' from dual;

or

set define off
select 'test123&1' from dual;

Will give the same result:
"test123&1"

Check the "set" command in sql*plus docs, lots more off handy stuff there.

Rob

"Marcel Stör" <marcel.stoer_at_complementa.ch> wrote in message news:99c7jt$4ld$1_at_pacifica.access.ch...
> hi folks
>
> if i try to execute the following command oracle asks to enter the value
 for
> mid, since it obviously interpretes it as a keyword or built-in function:
>
> select oid, pid, p2maincat from t_product where p2maincat = 'Equity
> Switzerland Small & mid Cap';
>
> how to avoid this? i need to tell the database even more clearly that
> everything right from the = is one single string.
>
> cheers, marcel
>
>
>
>
Received on Thu Mar 22 2001 - 02:00:20 CST