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;
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;
---------------
DIEN213DJEI
MSRITJDLS