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

The Oracle (tm) Users' Co-Operative FAQ

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

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 "