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
解决方案 »
- orcale 从 链接服务器 查数据的 SQL
- ORACLE数据导出问题,急用,万分感谢!
- 跪求ERP高手赐条语句
- oracle触发器动态表问题
- 请教大家一个SQL语句,谢谢!!!
- 想写个ORACLE在WIN2000下的批处理,用于自动启动数据库.
- 急!cursor结果集值改变,并返回结果集。在线等,很难,高手进,答出来立即给分。
- 请高手帮忙详细说明一下 like 这个模糊查询 % 不同位置的解释。或者给一个比较明显的例子。谢谢
- ORACLE8I安装问题,急。。。。。。
- 为什么我进不了SQL*PLUS???
- 求教:dbms_output.enable()有什么用
- Sql Server 與 Oracle 比較(store procedure)
给你一个地址,去下这本书来看看.
http://erwin.softwarechn.com/_script/showdowns.asp?Board=sql&Id=10&Tabname=oracle