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
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.

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

Current Time: Tue Jul 25 00:09:09 CDT 2017

Total time taken to generate the page: 0.14379 seconds