SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Find out Missing Numbers in a sequence

206604Sep 6 2010 — edited Sep 6 2010

Hi

We have a table ORDH, which is having a field ORDERNO which starts from 300000. currently there are around 100 thousand records exists in this table.
The ORDERNO value is generated from a sequence.
We want to find out the missing (hole in the sequence) ORDERNO from the ORDH table.
(Ex: 300654 is missing and there are lot of other order numbers were also missing)
Is there a way to find out all the missing order numbers from this table?

Thanks and Regards
Murali

This post has been answered by Frank Kulash on Sep 6 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 4 2010

Added on Sep 6 2010

5 comments

11,258 views