Re: Newbie !Help

From: Guy van den Berg <guy.vandenberg_at_compaq.com>
Date: Thu, 9 Mar 2000 12:16:18 +0100
Message-ID: <8a8167$1pg$1@mailint03.im.hou.compaq.com>

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'

---

testing this & 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