Re: a tricky sequence object question

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 7 Dec 2000 12:38:13 -0000
Message-ID: <90o0bp$k1v$1@soap.pipex.net>

how about using sqlplus to generate the file - untried example

spool c.sql
select
' create sequence ss increment by 1 start with '||max(id)||';' from table_name;
spool off
@c

--
Niall Litchfield
Oracle DBA
Audit Commission UK
<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 Thu Dec 07 2000 - 06:38:13 CST