使用子句：
ESCAPE。
例如：
select * from tab t where t.tname like 'B\_%' ESCAPE '\';
结果如下：
1 B_BOSSQUERY TABLE
2 B_BOSSQUERYERR TABLE
3 B_CALLBACK TABLE
4 B_CALLBACKERR TABLE
5 B_CHARGE TABLE
6 B_ORDER TABLE
英文如下：
You can include the actual characters "%" or "_" in the pattern by using the ESCAPE clause, which identifies the escape character. If the escape character appears in the pattern before the character "%" or "_" then Oracle interprets this character literally in the pattern, rather than as a special pattern matching character.
阅读(1114) | 评论(0) | 转发(0) |
