How to insert value 'a & b' in the varchar2 column.

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 INTO VALUES ('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