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