Hi all,
How to insert value 'a & b' in a varchar2 column? It takes '&' as promting for bind variable.
Thanks
Sanjay
Printable View
Hi all,
How to insert value 'a & b' in a varchar2 column? It takes '&' as promting for bind variable.
Thanks
Sanjay
Hi Sanjay,
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;
A1
----------
a&b
Thanks and regards
Debaditya
INSERT INTOVALUES ('a\&b')
It will do
It works.. Thanks much.
Sanjay
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?
Thanks