This will display the all
matching records and the records which are in right hand side table those that
are not in left hand side table.
Ex:
SQL> select
empno,ename,job,dname,loc from emp e right outer join dept d
on(e.deptno=d.deptno);
Or
SQL> select
empno,ename,job,dname,loc from emp e,dept d where e.deptno(+) =
d.deptno;
|
EMPNO
|
ENAME
|
JOB
|
DNAME
|
LOC
|
|
111
|
saketh
|
analyst
|
INVENTORY
|
HYBD
|
|
333
|
jagan
|
manager
|
INVENTORY
|
HYBD
|
|
222
|
sudha
|
clerk
|
FINANCE
|
BGLR
|
|
HR
|
MUMBAI
|
