Thursday, 10 September 2009

How to insert single or double quote into Oracle DB?

 Using q-quote string syntax, It can be done

Example :

INSERT INTO T(test) 
values (q'[single's quote and "double" quotes]');

No comments: