An Example of a Left Outer Join 1 : Outer Joins Left Right « Table Joins « Oracle PL/SQL Tutorial
SQL> SQL> SQL> SQL> -- create demo table SQL> create table Employee( 2 EMPNO NUMBER(3), 3 ENAME VARCHAR2(15 BYTE), 4 HIREDATE DATE, 5 ORIG_SALARY NUMBER(6), 6 CURR_SALARY NUMBER(6), 7 ......