how to update a sequence?

From: Norbert Lemke <ofenroor_at_gmx.de>
Date: Tue, 26 Jun 2001 16:29:18 +0200
Message-ID: <9ha682$cgdcd$1@ID-76747.news.dfncis.de>

Hi,

I have an oracle sequence, it generates unique keys (everything all right so far). With my Visual-Basic-GUI I can create single records 'insert into tab (id) values(seq.nextval)', and everything works fine.

But now I want to insert some bulk data, 10,000 records at once. I want to do this wiht the SAS-software, which has an own data format and own method for appending records.

First I read the next free sequence number (say 120,001), and since I know the number of new records (10,000) I want to update the sequence to 130,000 at once. Thereafter I can insert all records without any trouble. How can this be done? Is tere a method like 'update seq set currval=130000'?

Thanks,
Norbert Received on Tue Jun 26 2001 - 09:29:18 CDT