oracle 使用escape转义%与_匹配字符为本来含义
举例:
查找姓名为M%的员工。
select * from employee where staff_name like 'M\%' escape '\';
We only live once, and time just goes by.
举例:
查找姓名为M%的员工。
select * from employee where staff_name like 'M\%' escape '\';