a tricky sequence object question

Hi all

Any body know that how to create the sequence object in oracle in the way I want ???

I want a sequence object whose start with clauses is generic , I mean that I can select start with clause from a query , following example could give you more better idea

create sequence ss
increment by 1
start with (select max(id) from table_name)

That is all I want.

any help would be appreciated :)))

Faheem Rao

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Dec 06 2000 - 14:36:00 CST