Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> dynamic value for sequence

dynamic value for sequence

From: Ingo R. Kirchner <ingo.kirchner_at_t-online.de>
Date: Tue, 24 Sep 2002 17:29:43 +0200
Message-ID: <amq0c3$or5$03$1@news.t-online.com>


Hi,

I would like to create a sequence with a start value based on the maximal Value of the table

something like

create sequence software_seq
start with (select max(softwareid) from software)+1 increment by 1
nomaxvalue;

but it doesn't work this way

any help appreciated, thanks in advance

Ingo Received on Tue Sep 24 2002 - 10:29:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US