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