How to get the records which are not available in table 2 in oracle sql

Question

I have 2 tables.

table1

----------------------------------------
oid || oname     || desc      || creator
----------------------------------------
101    name101      desc101      cr101          
102    name102      desc102      cr102        
103    name103      desc103      cr103      
104    name104      desc103      cr104       
105    name105      desc105      cr105        

table2

----------------------------------------
sid || sname     || sloc      || oid
----------------------------------------
s101    sname101     sloc101      101       
s102    sname102     sloc102      102       
s103    sname103     sloc103      103         

Now I want the records from table1 which are not available in table 2.

104    name104      desc103      cr104                  
105    name105      desc105      cr105                 

What should be the sql query?

Answer 1

You can use not exists:

select t1.*
from table1 t1
where not exists (select 1 from table2 t2 where t2.oid = t1.oid);

Answer 2

SELECT t1.* FROM table1 t1 WHERE t1.oid NOT IN(SELECT t2.sid FROM table2 t2);

Answer 3

Use an OUTER JOIN:

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

dbfiddle here