DB/Oracle
oracle outer join or
냐옴
2012. 12. 6. 23:54
(X)
SELECT *
FROM A, B
WHERE A.COL1 = B.COL1(+)
AND B.COL2(+) IN ('C','D')
;
(O)
SELECT *
FROM A, B
WHERE A.COL1 = B.COL1(+)
AND DECODE(B.COL2(+), 'C', 1, 'D', 1, 0) = 1
;
(O)
SELECT *
FROM A, B
WHERE A.COL1 = B.COL1(+)
AND (B.COL2 IS NULL OR B.COL2 IN ('C','D'))
;