oracle 10g以上的版本 oracle select t.* from (select rownum as a,2*rownum b,3*rownum c from dual connect by level999) twhere t.a =123 and t.c 999--借用php小三哥的正则表达式and not regexp_like(to_char(a)||to_char(b)||to_char(c), '1.*?1|2.*?2|
oracle 10g以上的版本
oracle select t.* from (select rownum as a,2*rownum b,3*rownum c from dual connect by level=123 and t.c < 999--借用php小三哥的正则表达式and not regexp_like(to_char(a)||to_char(b)||to_char(c), '1.*?1|2.*?2|3.*?3|4.*?4|5.*?5|6.*?6|7.*?7|8.*?8|9.*?9|0', 'i')