Re: setting currval in a sequence without recreating the sequence
From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 10 Jul 2008 15:16:42 -0700
Message-ID: <1215728189.665949@bubbleator.drizzle.com>
Date: Thu, 10 Jul 2008 15:16:42 -0700
Message-ID: <1215728189.665949@bubbleator.drizzle.com>
seannakasone wrote:
> Can you set the currval in a sequence without having to drop and recreate
> the sequence? I rather not have to drop and recreate something because I
> have to do a lot more paperwork. Can't we just use alter or update?
> please provide example.
No. And CURRVAL does not exist in a sequence ... ever. CURRVAL exists within a session following a NEXTVAL call.
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Thu Jul 10 2008 - 17:16:42 CDT