Re: Rolling back sequences?

It's possible to roll back a sequence. All you have to do is to set the increment by value to -1 and call the sequence as often as you need it. You can of course also set incerement by to exactly the value you need to be subtracted from the actual value of nextval and call the sequence only once. Don't forget to set increment by to its default value 1 again!

Regards,

Jörg Received on Tue Apr 04 2006 - 04:57:14 CDT