Delete all records in TableA whose data in field1 and field2 DO NOT match the data in
fieldx and fieldz of TableB : DELETE WHERE « Insert Delete Update « Oracle PL / SQL
- Oracle PL / SQL
- Insert Delete Update
- DELETE WHERE
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 );
Related examples in the same category