Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle | Fetch only deleted records using MINUS operator

Vivek_Kolkata_CitiFeb 26 2018 — edited Feb 26 2018

Hi All,

I am using MINUS operator to fetch the records that don't match in two tables actual and backup table.

Select * from Table_BKP

MINUS

Select * from Table_Actual;

The above query shows both the records, the records that was updated to Table_Actual, and records that was deleted from Table_Actual.

I want only deleted records to display, is it possible ? Please help to provide the SQL.  Thanks in advance.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 26 2018
Added on Feb 26 2018
12 comments
585 views