Right Outer Joins « Table Joins « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Table Joins
  3. Right Outer Joins
1.right outer join between department table and employee table
2.Right outer joins:return all the rows from the table on the right instead of the table on the left
3.Group by and right join department id
4.Right Outer Join, room table and class table
5.Right Outer Join(room vs class)
6.Right join with where in clause