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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

how to find the missing sequence number

2649879Apr 8 2014 — edited Apr 29 2014

I have a table like this.

Seq_no date

----------- -----------

0000 01-apr-2014

0001 01-apr-2014

0002 01-apr-2014

.......

9999 10-apr-2014

0000 11-apr-2014

0001 11-apr-2014

.......

The last digit of sequence number start with 0000 and end with 9999 and when last digit exceeds 9999 it reset to 0000.

My question is : how can we find the missing sequence number for that column.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 27 2014

Added on Apr 8 2014

51 comments

23,568 views