Handle special character in oracle while inserting and updating.

Most of the time we are facing problem while inserting or updating special character in oracle database.

when executing the scripts it gives/ask to insert values for those fields which followed by special signature like "&"

How to insert special character in database ??

How to use ||chr(38) || in oracle ??

 

Solution is :-

In the query just replace "&" with ||chr(38) || and this will work