Re: How can I alter sequence ?

From: Ian Ledzion <ian.ledzion_at_lgxbow.com>
Date: Tue, 16 Oct 2001 15:00:50 +0200
Message-ID: <9qhb22$d3a$1@rex.ip-plus.net>

Why would you want to reset?

"Bts Rosy" <b_t_s_at_263.net> wrote in message news:005e624aaf4e0f68fcf5eea92be730cb.33476_at_mygate.mailgate.org...
> After I user sequence.nextval,the sequence.curval now is 20.
> But I want reset the curval,I hope sequence.curval=1,what I should do?
> Thanks!
>
>
> --
> Posted from [61.135.36.1]
> via Mailgate.ORG Server - http://www.Mailgate.ORG
Received on Tue Oct 16 2001 - 08:00:50 CDT

This message: [ Message body ]
Next message: Thomas Kyte: "Re: dbms_job and setting the interval"
Previous message: Dskdrv: "Truncation error retrieving 'long' through ODBC"
In reply to: Bts Rosy: "How can I alter sequence ?"
Next in thread: Howard J. Rogers: "Re: How can I alter sequence ?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US