Search This Blog

Wednesday, February 21, 2007

Insert "&"

There are TWO option.
1.set define off
2.set scan off


SQL> set define off
SQL> insert into tt values ('&test&test&test');

1 row created.

SQL> select * from tt;

NAME
--------------------
&test&test&test

No comments: