I have a table say TAB1. It has one field
f1 VARCHAR2(10)

I want to do something like

insert into TAB1 values('a&b');

where that '&' needs to go in as a string.

When I run thisd statement in SQL*Plus it is asking for the value of 'b'.

I want the '&' to be treated as a normal string instead of a special character. How do I do this.

I tried with

insert into TAB1 values('a\&b');

But it did not work......

Please help

Thank you