Monday, March 08, 2010

Set sequence to a predefined number

    alter sequence sequence_name increment by 800;

    select sequence_name.nextval from dual;

    alter sequence sequence_name  increment by 1;

No comments:

Post a Comment

Thank you for your feedback