oracle跳脫字元

jss001發表於2009-02-12
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

[@more@]

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/18921899/viewspace-1017266/，如需轉載，請註明出處，否則將追究法律責任。

相關文章