1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| WITH T AS (SELECT 710 code1, 720 code2, 180 code3 FROM dual
UNION ALL SELECT 910 code1, 620 code2, 580 code3 FROM dual
UNION ALL SELECT 910 code1, 620 code2, 180 code3 FROM dual
UNION ALL SELECT NULL code1, 180 code2, NULL code3 FROM dual
UNION ALL SELECT 180 code1, 620 code2, 780 code3 FROM dual
UNION ALL SELECT 180 code1, NULL code2, 780 code3 FROM dual
UNION ALL SELECT 180 code1, 620 code2, 7800 code3 FROM dual
)
SELECT *
FROM T
WHERE ';'|| code1 ||';'|| code2 ||';'|| code3 ||';' LIKE '%;7__;%;180;%'
OR ';'|| code1 ||';'|| code2 ||';'|| code3 ||';' LIKE '%;180;%;7__;%'
CODE1 CODE2 CODE3
710 720 180
180 620 780
180 780 |
Partager