Re: setting currval in a sequence without recreating the sequence
Date: Thu, 10 Jul 2008 17:02:49 -0700 (PDT)
On Jul 10, 11:55 am, seannakasone
> 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.
Can't we all just google along?
http://www.oracle.com/technology/oramag/code/tips2003/110903.html http://www.oracle.com/technology/oramag/code/tips2004/010404.html http://www.arikaplan.com/oracle/ari90298.html
Of course, that stuff is really old, so whether or not it works on current Oracle versions needs to be tested.
-- @home.com is bogus. http://www.sfgate.com/columnists/carroll/mondegreens.shtmlReceived on Thu Jul 10 2008 - 19:02:49 CDT