The AskTOM team is taking a break over the holiday season, so we're not taking questions or responding to comments. Please have a happy and safe festive season and as always, thanks for being a member of the AskTOM community.
Thanks for the question, Sean.
Asked: May 25, 2017 - 2:58 pm UTC
Last updated: May 26, 2017 - 2:24 am UTC
Version: Oracle 12.1
Viewed 1000+ times
SQL> select * from t; EMPNO ---------- 7369 7499 7521 7566 7654 7698 7782 7788 7839 7844 7876 7900 7902 7934 1234 5678 7423 5432 18 rows selected. SQL> SQL> select t.empno, 2 e.empno 3 from t, 4 scott.emp e 5 where t.empno = e.empno(+) 6 order by 1; EMPNO EMPNO ---------- ---------- 1234 5432 5678 7369 7369 7423 7499 7499 7521 7521 7566 7566 7654 7654 7698 7698 7782 7782 7788 7788 7839 7839 7844 7844 7876 7876 7900 7900 7902 7902 7934 7934 18 rows selected. SQL> SQL> select t.empno, 2 e.empno, 3 case when e.empno is null then 'Was not inserted' end msg 4 from t, 5 scott.emp e 6 where t.empno = e.empno(+) 7 order by 1; EMPNO EMPNO MSG ---------- ---------- ---------------- 1234 Was not inserted 5432 Was not inserted 5678 Was not inserted 7369 7369 7423 Was not inserted 7499 7499 7521 7521 7566 7566 7654 7654 7698 7698 7782 7782 7788 7788 7839 7839 7844 7844 7876 7876 7900 7900 7902 7902 7934 7934 18 rows selected.
Share and learn SQL and PL/SQL; free access to the latest version of Oracle Database!
Classes, workouts and quizzes on Oracle Database technologies. Expertise through exercise!