I have a table say TAB1. It has one field
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......