Re: Reset Sequence code

[Ramon E. Estevez]

Nice trick Joe !!! ----- Original Message ----- From: JOE TESTA To: Multiple recipients of list ORACLE-L Sent: Friday, July 05, 2002 8:48 AM Subject: Reset Sequence code NO, you dont need to DROP the sequence, here is demo code i used to reset a sequence(this resets it back to 1).   SQL> drop sequence test_seq;   Sequence dropped.   SQL> create sequence test_seq;   Sequence created.   SQL> SQL> declare   2   seq_hold_var number;   3  begin   4   for i in 1 .. 100000 loop   5   select test_seq.nextval into seq_hold_var from dual;   6   end loop;   7  end;   8  /   PL/SQL procedure successfully completed.   SQL> SQL> select test_seq.nextval from dual;      NEXTVAL                                                                      ----------                                                                          100001                                                                        SQL> SQL> alter sequence test_seq increment by -100000;   Sequence altered.   SQL> SQL> select test_seq.nextval from dual;      NEXTVAL                                                                      ----------                                                                               1                                                                        SQL> SQL> alter sequence test_seq increment by 1;   Sequence altered.