Outer Joins « Table Joins « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Table Joins
  3. Outer Joins
1.Outer Joins demo
2.Understanding Outer Joins: j.empno = e.empno (+)
3.Understanding Outer Joins: e.empno (+) = j.empno
4.Use an ANSI outer join and use the NVL function to convert nulls to the string "N/A".
5.Demo the ANSI outer join
6.Right outer join
7.Inner and Outer Joins(room and class)