Re: a tricky sequence object question

lock the table
find out the max value
dbms_sql.execute('create sequence ....);

not sure about the function within the packae but you can look for it manuals

<faheemrao_at_my-deja.com> wrote in message news:90m7vg$rm2$1_at_nnrp1.deja.com...
> 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 - 18:04:28 CST