15、ted.;几个测试方法:SELECT'myjsp?page=1&pagesize=10'FROMdual;SELECT'myjsp?page=1&pagesize=10'FROMdual;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;
16、 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 ''