[beginner] sequence

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Linux@Marco
    #1

    [beginner] sequence

    Hi!

    I have a question on the sequence, actually our...terrible database...has
    the sequence at the value 4 (in a ipotetic table) but the value that are in
    the table are with id (5,6,7,8,9,...3 0...) how can i forward the sequence to
    the value 30 ? ...

    Thanks....

    Marco



    Tags: None
    • Guido Konsolke
      #2
      Re: [beginner] sequence

      "Linux@Marc o" <mmueller@XXXXX 3denter.comwrot e...
      Hi!
      >
      I have a question on the sequence, actually our...terrible
      database...has
      the sequence at the value 4 (in a ipotetic table) but the value that
      are in
      the table are with id (5,6,7,8,9,...3 0...) how can i forward the
      sequence to
      the value 30 ? ...
      >
      Thanks....
      >
      Marco
      >
      Hi Marco,

      choose one of the following:

      1. Select the sequence's NEXTVAL 26 times.

      2. Modify the sequence's increment value to fit your need (remember
      to put it back in the original state after you finished your work).

      hth,
      Guido


        Comment

        Previous template Next
        Working...