PL/SQL (MOSC)

MOSC Banner

Data that differ between tables

in PL/SQL (MOSC) 1 commentAnswered

Hi team!

Could you please tell me how to compare differences between table and my select query and insert those results in separate table? My plan is to create one base table (name RESULT) by using select statement and populate it with current result set from select statement provided down. Then next day I would like to create procedure which will going to compare same select with RESULT table, and insert only results which differ (if I get changes on just one row then I want to catch only that) into another table called DIFFERENCES.

I'm using this query to populate RESULT table:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center