波斯汪
如果希望使语句易于读懂,则可以使用REGEXP_like(可从Oracle版本10开始)。一个示例表:SQL> create table mytable (something)
2 as
3 select 'blabla' from dual union all
4 select 'notbla' from dual union all
5 select 'ofooof' from dual union all
6 select 'ofofof' from dual union all
7 select 'batzzz' from dual 8 /Table created.原始语法:SQL> select something 2 from mytable 3 where something like 'bla%'
4 or something like '%foo%'
5 or something like 'batz%'
6 /SOMETH------blabla
ofooof
batzzz3 rows selected.和一个简单的REGEXP_like查询SQL> select something 2 from mytable 3 where regexp_like (something,'^bla|foo|^batz')
4 /SOMETH------blabla
ofooof
batzzz3 rows selected.但是.。我不推荐我自己,因为不太好的表现。我会坚持几个像谓词一样。所以这些例子只是为了好玩。