SQL sequence creation
Date: 29 Jul 2003 01:48:27 -0700
Message-ID: <3d21a3ae.0307290048.1e43705b_at_posting.google.com>
Hi there,
I'm trying to write a piece of sql to set an Oracle sequence's nextval
to a number specified my the max value in a set of columns. The
sequence is populating these columns, so I want to give it a kick if
something goes wrong so itwon't try to duplicate numbers.
I'm creating the sequence with
create sequence my seq
and I'm getting the required vlaue by a
select max(Col1) from (select Col1 from TAB1
union
minvalue 1
maxvalue 999999999999999999999999999
start with X
increment by 1
cache 20;
select Col2 from TAB2
union
.... etc. etc. etc.)
The question is how do I automatically get the single value in this into the X in the sequence? I tried placing the code in for the X, but got an ORA-01722 for it not being a proper number.
Ta in advance,
Steve.
Received on Tue Jul 29 2003 - 10:48:27 CEST