How to insert value 'a & b' in a varchar2 column? It takes '&' as promting for bind variable.
Use the following to insert a&b in a varchar2 column. I have used a test table d1 with a column a1.
SQL> set escape #
SQL> insert into d1 values ('a#&b');
1 row created.
SQL> select * from d1;
Thanks and regards
INSERT INTO VALUES ('a\&b')
It will do
It works.. Thanks much.
Besides "set define off", are there other way to do that?
Eg, insert into a values('a&b') in PL/SQL which is not SQL/PLUS env?
Click Here to Expand Forum to Full Width