Home » SQL & PL/SQL » SQL & PL/SQL » Compare sequences in two tables to find missing sequence no
Compare sequences in two tables to find missing sequence no [message #190210] Tue, 29 August 2006 13:21 Go to next message
coolguy01
Messages: 64
Registered: August 2006
Member
hey i have two tables with a similar type of column that conatin some sequence numbers. The second table is actually a table which conatins the missing sequence nos in the first table. Even then there may still be some more nos in the sequence missing..... so how do i compare both the tables to find the missing sequence nos or rows from both the table?? how do i compare the two tables??
Re: Compare sequences in two tables to find missing sequence no [message #190219 is a reply to message #190210] Tue, 29 August 2006 15:01 Go to previous message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
Whoops, I misread this duplicate post.

[Updated on: Tue, 29 August 2006 15:19]

Report message to a moderator

Previous Topic: Problem in BULK COLLECT and FORALL
Next Topic: Compare sequences in two tables to find missing sequence no
Goto Forum:
  


Current Time: Tue Apr 23 04:07:45 CDT 2024