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

The Oracle (tm) Users' Co-Operative FAQ

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

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"