"create sequence" statement and 'starting with' clause issue

Hello, i'm using Oracle 8.1.7 (but i need to make things working on 9 and 10g too).
I want to create a sequence using a SQL text file and launcihng with sqlplus.
My problem is that i want to initialize it at a value that depends from the database itself.
As far as i know, the "start with" clause in the "create sequence" statement needs a number... but i need a dinamic number (the results of a query).

I even tried to make a pl/sql script, but it seem the "create sequence" statement is not supported in pl/sql

Any idea?
thanks,
termoPilucco Received on Mon Nov 20 2006 - 03:30:59 CST