OUTER JOIN

select e.name, d.dept_id, d.name from s_emp e LEFT OUTER JOIN s_dept d 

ON e.dept_id = d.dept_id;

select e.name, d.dept_id, d.name from s_emp e, s_dept d 

where e.dept_id = d.dept_id(+);

select e.name, d.dept_id, d.name from s_emp e RIGHT OUTER JOIN s_dept d 

ON e.dept_id = d.dept_id;

select e.name, d.dept_id, d.name from s_emp e,s_dept d 

where e.dept_id(+) = d.dept_id;

select e.name, d.dept_id, d.name from s_emp e FULL OUTER JOIN  s_dept d 

on e.dept_id=d.dept_id;