escape就是这样的。
对于'AAB' ESCAPE 'A' 它会escape第一个'A'
而对于'AAAB' ESCAPE 'A' ，它会直接匹配'AAAB',就相当于没有escape
你仔细看看escape的用法就明白了。
Let P1, P2, ..., Pn be these subpatterns. The like condition is true if there is a way to
partition the search value into substrings S1, S2, ..., Sn so that for all i between 1 and n:
*If Pi is _, then Si is a single character.
*If Pi is %, then Si is any string.
*If Pi is two characters beginning with an escape character, then Si is the second
character of Pi.
* Otherwise, Pi = Si.请看oracle文档sql reference
http://gigabase.idi.ntnu.no/oradoc/nav/docindex.htm
对于'AAB' ESCAPE 'A' 它会escape第一个'A'
而对于'AAAB' ESCAPE 'A' ，它会直接匹配'AAAB',就相当于没有escape
你仔细看看escape的用法就明白了。
Let P1, P2, ..., Pn be these subpatterns. The like condition is true if there is a way to
partition the search value into substrings S1, S2, ..., Sn so that for all i between 1 and n:
*If Pi is _, then Si is a single character.
*If Pi is %, then Si is any string.
*If Pi is two characters beginning with an escape character, then Si is the second
character of Pi.
* Otherwise, Pi = Si.请看oracle文档sql reference
http://gigabase.idi.ntnu.no/oradoc/nav/docindex.htm
给你一个地址,去下这本书来看看.
http://erwin.softwarechn.com/_script/showdowns.asp?Board=sql&Id=10&Tabname=oracle