Oracle: Full Outer Join or Full Join

Full Outer join is the combination of Right Join and left join. That means we can say that the outer join outputs the entire data present in the dataset. Follow the below diagram to understand the concept better:

Full Outer Join

Syntax

Select Column from Table1 FULL OUTER JOIN Table2
on Table1.column= Table2.column;

Example

We have two tables Stu and Marks1. Refer below to see values in tables:

Stu Table is as follows:

Full Outer Join

Marks1 table is as follows:

Full Outer Join

Now if we apply outer join in both the above table. the code is as follows:

select * from Stu s full Outer Join Marks1 m 
on s.Roll_no= m.Roll_no;

Output

Full Outer Join