oracle 正则表达式不包含某个字符串

fandajun4000 2012-07-05 05:32:28

ORACLE 正则表达式不包含一个字符串的表达式怎么写?

比如 SELECT T.*, T.ROWID
FROM TMP_TAB T
WHERE regexp_like(CODE, '.*(!0791).*'); (该表达式错误) 不包含0791这个字符串的任意字符串？怎么写？

在线等

...全文

1325 4 打赏收藏转发到动态举报

写回复

用AI写文章

4 条回复

切换为时间正序

请发表友善的回复…

发表回复

大明湖畔_帅锅 2012-07-07

打赏
举报

这种？

WHERE not regexp_like(CODE, '0791')

zxcv88888 2012-07-07

打赏
举报

where INSTR(XXX,XX)<=0

q806294478 2012-07-06

打赏
举报

CODE            

--------------- 

DIEN213DJEI     

MSRITJDLS

q806294478 2012-07-06

打赏
举报

WITH T AS(

SELECT 'MSRITJDLS' AS CODE FROM DUAL

UNION

SELECT '215DJFE0791DJEI' FROM DUAL

UNION 

SELECT 'DIEN213DJEI' FROM DUAL

UNION 

SELECT '0FFR0791DJEI' FROM DUAL

)

SELECT * FROM T 

WHERE INSTR(CODE,'0791')=0;

结果如下：

WITH T AS(

SELECT 'MSRITJDLS' AS CODE FROM DUAL

UNION

SELECT '215DJFE0791DJEI' FROM DUAL

UNION 

SELECT 'DIEN213DJEI' FROM DUAL

UNION 

SELECT '0FFR0791DJEI' FROM DUAL

)

SELECT * FROM T 

WHERE INSTR(CODE,'0791')=0;