create sequence with subqueryfor starting value?

I would like to write a simple script to create a sequence and assign it a starting value of the current high value of the related column, something like this:

create sequence my_seq start with ( select max(unique_key) from my_table; );

No matter what I do, Oracle comes back with 'not a number'.

Is there a way to do this without dynamically creating and running a script file?

Thanks,
Neil Received on Sun Sep 30 2001 - 09:22:47 CDT