17,086
社区成员
发帖
与我相关
我的任务
分享
WITH TMP AS
(SELECT 1 FLG
FROM DUAL
UNION ALL
SELECT 2 FLG
FROM DUAL
UNION ALL
SELECT 3 FLG
FROM DUAL
UNION ALL
SELECT 4 FLG
FROM DUAL)
SELECT *
FROM (SELECT FLG,
DECODE(FLG,
1,
'已经处理',
2,
'尚未处理',
3,
'忽略处理',
4,
'错误的处理方法') PVALUE
FROM TMP) T
WHERE T.PVALUE LIKE '忽略%';
WITH TMP AS
(SELECT 1 FLG, '已经处理' PVALUE
FROM DUAL
UNION ALL
SELECT 2 FLG, '尚未处理' PVALUE
FROM DUAL
UNION ALL
SELECT 3 FLG, '忽略处理' PVALUE
FROM DUAL
UNION ALL
SELECT 4 FLG, '错误的处理方法' PVALUE
FROM DUAL)
SELECT * FROM TMP T WHERE T.PVALUE LIKE '%忽略%'