Re: Escape character.

You may shut off substitution prompting by doing the following:

SQL> set define off;

thats all there is to it!

Heres an example:

SQL> select '&j' from dual;
Enter value for j:
User requested Interrupt or EOF detected.

SQL> set define off;
SQL> select '&j' from dual;

'&
--
&j

-Jay

C. wrote:

> Hi All,
> Can anyone tell me what the escape character is for the & when trying
> to insert a string that contains the ampersand?
> Thanks in advance,
> Cindy Ferguson, c_ferguson_at_rationalconcepts.com
Received on Thu Jun 24 1999 - 21:56:16 CDT