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 to reset all sequence to 0 or 1 at time?

VPSJul 3 2008 — edited Jul 3 2008

Friends,

OS: RHEL AS 3
DB: 9iR2

I have some 187 sequences. i want to reset all the sequences to "0" or "1" at a time.
how can i do that?
i its a single sequence, then i will do the below...

for example if i have the x.nextval is 4
alter sequence x increment by -4;
alter sequence x increment by 1;

the above is only for x but i have x,y,z,.......upto 187 sequences...
how can i do that?
any triggers or procedures? or any quick method.

thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 31 2008

Added on Jul 3 2008

12 comments

2,521 views