Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie !Help
You can also use an escape char as below if you only want to do it once and
not turn it off altogether using set scan off.
SQL> set escape '\' SQL> set escape on SQL> select 'testing this \& that' from dual;
'TESTINGTHIS&THAT'
SQL>
HTH
g.
--
Guy van den Berg
External Consultant
Compaq Computers BV
gene wrote in message <8a62ke$9id$1_at_nntp.bull.com>...
>How do I tell Oracle to ignore the meaning of a special character (&) in a
>SQL script.
>
>Thanks
>Gene
>
>
Received on Thu Mar 09 2000 - 05:16:18 CST
![]() |
![]() |