This will display the all
matching records and the non-matching records from both tables.
Ex:
SQL> select
empno,ename,job,dname,loc from emp e full outer join dept d
on(e.deptno=d.deptno);
|
empn
|
ename
|
job
|
dname
|
loc
|
|
333
|
jagan
|
mangr
|
invntry
|
hybd
|
|
111
|
saketh
|
analyst
|
invntry
|
hybd
|
|
222
|
sudha
|
clerk
|
finance
|
hybd
|
|
444
|
madu
|
engnr
|
||
|
hr
|
mumb
|