消除Oracle通配符的特殊含义

SQL> select * from test;
ID NAME ---------- -------------------- 1 a_ 2 bb_ 3 ccc 4 dddd_

SQL> select * from test where name like '%\_' escape '\';

ID NAME
---------- --------------------
1 a_
2 bb_
4 dddd_