oracleinstr函数用法和(oracle用instr来代替like)(二)

COUNT(*)
―――-
5478

Elapsed: 00:00:31.47
SQL> select count(*) from t where instr(title,’oracle’)=0;

COUNT(*)
―――-
994530

Elapsed: 00:00:11.31
SQL> select count(*) from t where title not like ‘%oracle%’;

COUNT(*)
―――-
994530

注:

instr(title,'oracle’)>0 相当于like

instr(title,'oracle’)=0 相当于not like