select ... from ... where ... like '/_%' escape '/';
3、
insert into t(col) values(chr(ascii('&'))) ;
(方法一)
例:插入特殊字元’&’
SQL> SHOW DEFINEdefine "&" (hex 26) ? SET DEFINE OFFSQL> SHOW DEFINEdefine OFFSQL> INSERT INTO
VALUES ('AT&T');
/
1 row created
(方法二)
SQL> SHOW ESCAPEescape OFF SET ESCAPE ONSQL> SHOW ESCAPEescape "\" (hex 5c)SQL> INSERT INTO temp_table VALUES ('select * from emp where ename =\&1');
1 row created.
;
几个测试方法:
SELECT 'myjsp?page=1&pagesize=10' FROM dual;SELECT 'myjsp?page=1&pagesize=10' FROM dual;SQL> create table a (b varchar2(10)); Table created SQL> insert into a values('_a');
1 row inserted
SQL> select B from A where instr(b,'_a')>0; B ---------- _a select B from A where b like '%\_a%' escape '\'
先启动转义符
set escape on
select B from A where b like '%\_a%' escape '\';select B from A where b like '%\_a%' escape '\';