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 ? |
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"
最后修改时间：2020-04-16 15:13:13
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
