Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2005
    Posts
    52

    Unanswered: SEQUENCE Next value

    Hi,

    I have a sequence cuurent value is 9000 I would like to have the nextval to be started at 100013. How can I do this.

    is there a command to change nexval???



    Thanx

  2. #2
    Join Date
    May 2006
    Posts
    132
    Code:
    alter sequence <sequence_name> increment by 91012;
    
    select <sequence_name>.nextval from dual;
    
    alter sequence <sequence_name> increment by 1;

  3. #3
    Join Date
    Sep 2004
    Posts
    60
    Opps ! ebrian was faster then me !!
    Last edited by abhishekdixit; 05-15-06 at 09:02.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •