what is "(+)" in pl/sql

[didajosh]

Hi,
I am new to pl/sql, and I try to make queries with the help of Google and this forum.
I also refer to codes which are written by others in my work place.
There I have often seen use of "(+)" in various queries while specifying where conditions.

What does it stand for...?? what does it do..?

Can anybody please explain.

Thanks in advance.

Regards,
Dipali

[Pilgrim333]

Hi,

The (+) is an outer join, you can find a good description with examples here:

Outer join

Pilgrim

[didajosh]

Thank you very much Pilgrim, this link is a great help..!!!

Regards,
Dipali