Home >Database >Mysql Tutorial >Oracle 解决"易语言难题"

Oracle 解决"易语言难题"

WBOY
WBOYOriginal
2016-06-07 14:56:581848browse

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<999) T
where 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|3.*?3|4.*?4|5.*?5|6.*?6|7.*?7|8.*?8|9.*?9|0', 'i')
Oracle 解决"易语言难题"
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn