The Oracle (tm) Users' Co-Operative FAQ

How do I embed single-quote marks in an SQL statement ?


Author's name: Michael Eichler

Author's Email:meichler@proteus.com

Date written: 4th March 2002

Oracle version(s): 8.1

How do I embed single-quote marks in an SQL statement

Back to index of questions


Simply escape it with another single-quote.  For example, try

	SELECT 'New Year''s Day' FROM dual;

and you will get the text formatted appropriately, including the single quote..


Further reading: See also "How do I I insert an apostrophe (') into a column using simple SQL "


Back to top

Back to index of questions