Home » SQL & PL/SQL » SQL & PL/SQL » Compare Table and Snapshot (Compare Table and Snapshot)
Compare Table and Snapshot [message #274103] Sat, 13 October 2007 19:31 Go to next message
ravichandran_123
Messages: 13
Registered: October 2007
Location: Bangalore
Junior Member
Hi Experts,

Here is my requirement. First I have a load table LOAD_TABLE (with 50 columns) and i will take a snapshot of that table with only 2 key columns as LOAD_SNAPSHOT. Next time when I load the data into the stage table, I want to compare the data in the LOAD_TABLE and LOAD_SNAPSHOT. Could you please let me know how to compare a table and snapshot?

Thanks a lot in advance.

Ravi
Re: Compare Table and Snapshot [message #274105 is a reply to message #274103] Sat, 13 October 2007 20:35 Go to previous message
BlackSwan
Messages: 25049
Registered: January 2009
Location: SoCal
Senior Member
One way is by using
SQL> SELECT ..... 
     MINUS 
     SELECT.....
Previous Topic: problem with use of array
Next Topic: Querying on hierarchical tables
Goto Forum:
  


Current Time: Fri Dec 09 11:40:08 CST 2016

Total time taken to generate the page: 0.09023 seconds