SQL使用单引号 

SQL> select 'xxxx'oooo' from dual;
ERROR:
ORA-01756: quoted string not properly terminated


SQL> select "xxxx'oooo" from dual;
select "xxxx'oooo" from dual
       *
ERROR at line 1:
ORA-00904: "xxxx'oooo": invalid identifier


SQL> select q'[xxxx'oooo]' from dual;

Q'[XXXX'O
---------
xxxx'oooo

posted @ 2014-05-18 16:12  czcb  阅读(170)  评论(0)  编辑  收藏  举报