Re: a tricky sequence object question

Is this something you're planning on doing for a number of times? Meaning that if you are you are looking into creating something generic for you to be able to execute in the future? Or is this just a one time thing?

If just a one time thing, you can just update the columns in all_sequences (or user_sequences) to satisfy your requirements. Edit the min_value and last_number columns of the table.

Cheers,
BB

In article <90m7vg$rm2$1_at_nnrp1.deja.com>,   faheemrao_at_my-deja.com wrote:
> 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.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Dec 07 2000 - 12:33:54 CST