Insert Delete Update Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Insert Delete Update
  4. Delete all records in TableA whose data in field1 and field2 DO NOT match the data in fieldx and fieldz of TableB
DELETE FROM TableA
    WHERE NOT EXISTS
      ( select *
         from TableB
         where TableA .field1 = TableB.fieldx
         and TableA .field2 = TableB.fieldz );