用来表示it’s a person
SQL> select ename||'it'a person' from emp where deptno=10
2 ;
ERROR:
ORA-01756: 引号内的字符串没有正确结束
解决方法:
SQL> select ename||' it''s a person' from emp where deptno=10;
ENAME||'IT''APERSON'
---------------------
aa it's a person
CLARK it's a person
KING it's a person
MILLER it's a person
SQL> select ename||' it'||chr(39)||'s a person' from emp where deptno=10;
ENAME||'IT'||CHR(39)||'SA
-------------------------
aa it's a person
CLARK it's a person
KING it's a person
MILLER it's a person
SQL> select ename||' it'||''''||'s a person' from emp where deptno=10;
ENAME||'IT'||''''||'SAPE
------------------------
aa it's a person
CLARK it's a person
KING it's a person
MILLER it's a person