| 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 ? | |
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"