The Oracle (tm) Users' Co-Operative FAQ

How do I insert an apostrophe (') into a column using simple SQL ?


Author's name: Michael Eichler

Author's Email:meichler@proteus.com

Date written: 4th March 2002

Oracle version(s): 8.1

How do I insert an apostrophe (') into a column using simple SQL ?

Back to index of questions


Example:

	INSERT INTO foo VALUES ('''');  

The first and last single quotes say, "the contents are a string" and the second single quote "escapes" the third.
..


Further reading: See also "How do I embed single-quote marks in an SQL statement"


Back to top

Back to index of questions