SELECT tbl1.R1, tbl1.R2
FROM (select 'ABC' as A1,
'123' as R1,
'112233' as R2,
'' as C1,
'1' as C2,
'' as C3,
'' as C4
from dual) tbl1
WHERE
'ABC' = tbl1.A1
AND CASE WHEN tbl1.C1 IS NOT NULL
THEN '123' = tbl1.R1 AND '112233' = tbl1.R2
WHEN tbl1.C2 IS NOT NULL
THEN '123' = tbl1.R1 AND '112233' = tbl1.R2
WHEN tbl1.C3 IS NOT NULL
THEN '123' = tbl1.R1 AND '112233' = tbl1.R2
WHEN tbl1.C4 IS NOT NULL
THEN '123' = tbl1.R1 AND '112233' = tbl1.R2
ELSE NULL
END;
Error:
ORA-00905: missing keyword
00905. 00000 - "missing keyword"
*Cause:
*Action: