1、用chr函数,找到单引号的asscii
SQL> select * from test1 where description like '%'||chr(39)||'%';
ID DESCRIPTION
----------- --------------------------------------------------
11 hanjs''hanjs
111 hanjs'hanjs
SQL>
2、'' 代表一个 '
SQL> insert into test1 values (111,'hanjs''hanjs');
1 row inserted
SQL> select * from test1 where id=111;
ID DESCRIPTION
----------- --------------------------------------------------
111 hanjs'hanjs
SQL> select * from test1 where description like '%''%';
ID DESCRIPTION
----------- --------------------------------------------------
11 hanjs''hanjs
111 hanjs'hanjs
SQL>
SQL> select * from test1 where description like '%'||chr(39)||'%';
ID DESCRIPTION
----------- --------------------------------------------------
11 hanjs''hanjs
111 hanjs'hanjs
SQL>
2、'' 代表一个 '
SQL> insert into test1 values (111,'hanjs''hanjs');
1 row inserted
SQL> select * from test1 where id=111;
ID DESCRIPTION
----------- --------------------------------------------------
111 hanjs'hanjs
SQL> select * from test1 where description like '%''%';
ID DESCRIPTION
----------- --------------------------------------------------
11 hanjs''hanjs
111 hanjs'hanjs
SQL>