Description
An outer join predicate specifies two tables and returns a result table that contains all of the rows from one of the tables, even if there is no matching row in the other table. See Outer Joins for more information.
Syntax
outer_join_predicate ::
[ table_name. ] column = [ table_name. ] column (+)
| [ table_name. ] column (+) = [ table_name. ] column