Oracle FULL OUTER JOIN with Example
In Oracle the FULL OUTER JOIN is used to Select all records when there is a match in either left or right table.
FULL OUTER JOIN Syntax
SELECT column_name(s)
FROM table1
FULL OUTER JOIN table2 ON table1.column_name = table2.column_name;
