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!

how find out the missing number from a sequence

482588Apr 24 2006 — edited Apr 24 2006

here is the table

ID Name
1 AA
2 BB
3 CC
4 DD
6 FF
7 GG

The ID col should contain consecutive numbers, how can I find out that number "5" is missing from the table if i know the range is from 1 to 7?

Locked Post

New comments cannot be posted to this locked post.

Locked on May 22 2006

Added on Apr 24 2006

6 comments

2,573 views