Preserves all rows of the right-specified table reference and
    matches to rows in the left-specified table reference in the
    result. NULL appears in columns where there is no match in the
    left-specified table reference. For example:

    SQL> SELECT *
    cont> FROM TABLE1 RIGHT OUTER JOIN TABLE2
    cont> ON TABLE1.C1 = TABLE2.C1;
       TABLE1.C1     TABLE1.C2     TABLE2.C1   TABLE2.C4
              10            15            10   AA
            NULL          NULL            15   BB
              20            25            20   CC
    3 rows selected

    Notice that the FULL OUTER JOIN example result is the same as the
    INNER JOIN example result plus the unmatched rows from TABLE1 and
    unmatched rows from TABLE2.