How to create a sequence with a dynamic start value
From: Norbert Pürringer <thalion77_at_graffiti.net>
Date: Thu, 12 Jun 2008 00:17:26 -0700 (PDT)
Message-ID: <7e2bbe35-0ea3-491e-ae65-d495c50fab79@y21g2000hsf.googlegroups.com>
Date: Thu, 12 Jun 2008 00:17:26 -0700 (PDT)
Message-ID: <7e2bbe35-0ea3-491e-ae65-d495c50fab79@y21g2000hsf.googlegroups.com>
Hello,
what is the best way to create a sequence with a dynamic start value.
The following statement is not valid:
create sequence TEXT_SEQ start with select NVL(max(ID),0) + 1 from
TEXT;
Thank you,
Norbert
Received on Thu Jun 12 2008 - 02:17:26 CDT