Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE TABLE1 AS
SELECT 101 AS OID, 'name101' AS ONAME, 'desc101' AS "DESC", 'cr101' AS CREATOR FROM DUAL UNION ALL
SELECT 102, 'name102', 'desc102', 'cr102' FROM DUAL UNION ALL
SELECT 103, 'name103', 'desc103', 'cr103' FROM DUAL UNION ALL
SELECT 104, 'name104', 'desc103', 'cr104' FROM DUAL UNION ALL
SELECT 105, 'name105', 'desc105', 'cr105' FROM DUAL
5 rows affected

CREATE TABLE TABLE2 AS
SELECT 's101' AS SID, 'sname101' AS SNAME, 'sloc101' AS SLOC, 101 AS OID FROM DUAL UNION ALL
SELECT 's102', 'sname102', 'sloc102', 102 FROM DUAL UNION ALL
SELECT 's103', 'sname103', 'sloc103', 103 FROM DUAL;
3 rows affected

SELECT t1.*
  FROM TABLE1 t1
  LEFT OUTER JOIN TABLE2 t2
    ON t2.OID = t1.OID
  WHERE t2.OID IS NULL
  ORDER BY t1.OID


OID
ONAME
DESC
CREATOR


104
name104
desc103
cr104

105
name105
desc105
cr105