How can I alter sequence ?

From: Bts Rosy <b_t_s_at_263.net>
Date: Tue, 16 Oct 2001 08:24:03 +0000 (UTC)
Message-ID: <005e624aaf4e0f68fcf5eea92be730cb.33476@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 - 03:24:03 CDT

This message: [ Message body ]
Next message: harry: "OracleOraHome81Agent service hung on starting"
Previous message: Niall Litchfield: "Re: Where to keep encryption key , DB?"
Next in thread: Andreas Stephan: "Re: How can I alter sequence ?"
Reply: Andreas Stephan: "Re: How can I alter sequence ?"
Reply: Valery Yourinsky: "Re: How can I alter sequence ?"
Reply: Ian Ledzion: "Re: How can I alter sequence ?"
Reply: 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