Tuesday, October 9, 2007

How to retrieve a Sequence Value?

What is the easiest way to set a sequence to a very high value.

E.g. currval = 100, set it to point to 1100.

Instead of dropping and recreating the sequence again, use the INCREMENT BY option to reset a sequence value. You can also decrement the sequence value by incrementing it with a negative number. Don't forget to reset the increment value to 1 or as the case.

Alter sequence x increment by 1000;select x.nextval from dual;Alter sequence x increment by 1; Tip taken from:http://www.amar-padhi.com/oradb_seq_reset.html

4 comments:

  1. The AP reported that Manziel's lawyer Bob Hinton mistakenly sent the AP a long text message, which he said later was meant for another attorney,wholesale Indiana Colts flags,
    cheap Indianapolis Colts flags,nfl sports flags

    ReplyDelete
  2. Da allora a oggi le squadre sono cambiate ma nemmeno troppo. Camisetas de futbol baratas,camisetas AC Milan,
    camisetas As Roma baratas

    ReplyDelete