OraFAQ Forum: SQL & PL/SQL » Compare Table and Snapshot

Home » SQL & PL/SQL » SQL & PL/SQL » Compare Table and Snapshot (Compare Table and Snapshot)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Compare Table and Snapshot [message #274103]

Sat, 13 October 2007 19:31

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

Report message to a moderator

Re: Compare Table and Snapshot [message #274105 is a reply to message #274103]

Sat, 13 October 2007 20:35

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

One way is by using

SQL> SELECT ..... 
     MINUS 
     SELECT.....

Report message to a moderator

Previous Topic:	problem with use of array
Next Topic:	Querying on hierarchical tables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 11 04:23:00 CDT 2025