OUTER JOIN
Outer join gives the non-matching records along with matching records.
LEFT OUTER JOIN
Left outer join produces a complete set of records from
Table A, with the matching records (where available) in Table B. If there is no
match, the right side will contain null..
Ex:
SQL> select
empno,ename,job,dname,loc from emp e left 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
|
444
|
madhu
|
engineer
|