Re: How to create a sequence with a dynamic start value

On Jun 12, 2:17 am, Norbert Pürringer <thalio..._at_graffiti.net> wrote:
> 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

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