Oracle database joins

Question

Suppose there is one condition,

(+) =

i know (+) used in join of column but what does it mean in this condition

That's the old, deprecated Oracle outer join syntax, can't remember if it's `left join` or `right join`. — jarlh, Apr 21 '16 at 06:38

score 2 · Answer 1 · answered Apr 21 '16 at 06:41

The Oracle (+)= syntax is the equivalent for OUTER JOINS.

a.column (+)= b.column

means "retrieve the record from b even if there is no match with a" (RIGH OUTER JOIN)

a.column = b.column (+)

means "retrieve the record from a even if there is no match with b" (LEFT OUTER JOIN)

1 Answers1