Oracle中的字符串引号''转义
SELECT ' It''s a bird, no plane, no it can''t be ice cream! ' AS phrase2 FROM DUAL;
等于
SELECT q' (It's a bird, no plane, no it can't be ice cream!) ' AS phrase2 FROM DUAL;
posted on 2014-05-20 22:38 Sunny_NUAA 阅读(667) 评论(0) 编辑 收藏 举报