Skip to Main Content
Forums

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!

finding unused values in a sequence !

Nalla (Nallasivam)Jun 11 2008 — edited Jun 11 2008
Hi Frenz,

I have a sequence that is used by many procs. Say the seq has a start value 1 and ending value 100.
I wanted to find all the values for that sequence that has not been added to the table.

(say when seq had the value 30 for it, I tested to see if seq is workin and so the value 30 won't be used/added anymore to the tables)

I dont think any code for the proc is needed !

Thanks in advance
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 9 2008
Added on Jun 11 2008
11 comments
951 views