An outer join predicate specifies two tables and returns a result table that contains all the rows from one of the tables, even if there is no matching row in the other table.

Syntax

 [ table_name. ] column  =  [ table_name . ] column  (+) 
   | [ table_name.]column (+) = [table_name.]column