Re: How to create a sequence with a dynamic start value
Date: Fri, 13 Jun 2008 04:44:57 -0700 (PDT)
On Jun 12, 2:17 am, Norbert Pürringer <thalio..._at_graffiti.net> wrote:
> 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
> Thank you,
The core question is why do you need to do that? also why do you need to do it in one statement? Ed Received on Fri Jun 13 2008 - 06:44:57 CDT