/* Using full outer joins in Oracle */

SELECT s.fname, s.lname, c.course_id  
FROM   student s  FULL JOIN  class c  
    ON s.ssn = c.stu_ssn