How to Use (+) in ORACLE and how to use it in oracle

How to Use (+) in ORACLE and how to use it in oracle

(+) Is the connection

For example

SELECT a. *, B. * from a (+) = B is a right join, equivalent to select a. *, B. * from a right join B

SELECT a. *, B. * from a = B (+) is a left join, equivalent to select a. *, B. * from a left join B

That is, the other side of the "(+)" location is the connection direction. When a full set is connected to a part of the set, the column of some sets is followed by (+ ), to achieve the effect of null when there is no matching

Do you understand?