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部落格 ” ，連結：http://blog.itpub.net/756652/viewspace-242274/，如需轉載，請註明出處，否則將追究法律責任。