select 1 from dual where 'bac%d' like '%/%%' escape '/' 转义
SQL> select 1 from dual where 'bacd' like '%/%%' escape '/'; 1 ----------SQL> select 1 from dual where 'b%a%c%%d' like '%/%%' escape '/'; 1 ---------- 1
select 1 from dual where 'bac%d' like '#%%' escape '#' ;
转义
----------SQL> select 1 from dual where 'b%a%c%%d' like '%/%%' escape '/'; 1
----------
1
http://bbs.dameng.com
====================================
select 1 from dual where regexp_like(字段名,'%');
每天推荐一点基础知识?