Fast Reset Sequences (Alternative)

(Ilya Petrenko) In a previous tip, Fast Reset Sequences, I showed how to reset a sequence to MinValue with few calls to the data dictionary (SQL and PL/SQL implementations). The following script below is another approach to achiev the same result with even fewer calls. This technique is very useful

Read More - Register for Free Membership