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编辑  收藏  举报

导航