oracle转义字符
SQL> select * from test;
ID
------------------------------------------------------------
c_zhang
zhangsan
cccccc
SQL> select id from test where id like 'c_%' escape '';
ID
------------------------------------------------------------
c_zhang
SQL> select id from test where id like 'c=_%' escape '=';
ID
------------------------------------------------------------
c_zhang
SQL> select id from test where id like 'c/_%' escape '/';
ID
------------------------------------------------------------
c_zhang
http://www.itpub.net/showthread.php?s=&threadid=631150
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/756652/viewspace-242274/ ，如需转载，请注明出处，否则将追究法律责任。
