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.