Outer join

[dham]

Good afternoon guys

I'm a beginner in Oracle and I have a question about (+) Outer Join, I made examples in which it works but I could not understand the real utility of it.

If someone can give me one explained about it.

grateful

Daniel Henrique

[diegolenhardt]

When in your relationship one of the sides of the comparison of the WHERE may have null values, the query will return records indepently from the WHERE Clause,

[Trevisolli]

This same ...

I always think as follows when I use Outer (left or rigth):
"Bring me the consultation data, regardless of whether you have ( equal information) or not (do not have) on the other side information ".

[dham]

Grateful for the answer, clarified doubt.

Daniel Henrique

[edson.amorim]

Dear,

This can also be done using the (+) in front of the field where you want to list null, is that right?