Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> dynamic value for sequence
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