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.

seannakasone (snakason (AT) pgsnakason (DOT) hawaiianelectric.net) 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.

Loop over nextval until you get to the number you want (assuming you
want a higher number).

seannakasone (snakason (AT) pgsnakason (DOT) hawaiianelectric.net) 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.

Loop over nextval until you get to the number you want (assuming you
want a higher number).

seannakasone (snakason (AT) pgsnakason (DOT) hawaiianelectric.net) 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.

Loop over nextval until you get to the number you want (assuming you
want a higher number).

seannakasone (snakason (AT) pgsnakason (DOT) hawaiianelectric.net) 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.

Loop over nextval until you get to the number you want (assuming you
want a higher number).

seannakasone wrote:
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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

seannakasone wrote:
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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

seannakasone wrote:
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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

seannakasone wrote:
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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

On Jul 10, 11:55*am, seannakasone
<snaka... (AT) pgsnakason (DOT) hawaiianelectric.net> wrote:
Can't we all just google along?

http://www.oracle.com/technology/ora...03/110903.html
http://www.oracle.com/technology/ora...04/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.

jg
--
@home.com is bogus.
http://www.sfgate.com/columnists/car...degreens.shtml