Hi,
I am trying to insert a string which is having ampersand in it,how do i escape &.
Ex: I have a table with a column saying status varchar2(30).
Now, i want to insert a string like thick & thin in that column.
INSERT INTO DUMMYTABLE VALUES('thick & thin');
It is prompting for thin when i gave like above..
Please help me regarding this.
Thanks and Regards,
Hafeez.
