SQL*LOADER & SEQUENCE VALUES

From: Caston Jackson <cjacksn_at_mindspring.com>
Date: 11 Mar 2000 16:31:30 GMT
Message-ID: <8EF479BB5cjacksnmindspringcom_at_198.99.146.100>

[Quoted] Any ideas on how to use a sequece number that is sequenced every time a group of records are imported ?

i.e. if the columns in the table are as below

            IMPORTVAL, TEST1, TEST2 every time an import of x records occurs the IMPORTVAL should be incremented by 1.

Therefore group 1 of 1000 records would have a value of 100

    	    	group 2 of 2000 must have a value of 101
    	    	group 3 of 150 must have a value of 102

each group is an insert of records.

The problem I have found with SQL*LOADER is that you can call the sequence value nextval however the value will increment for each record. To add to the problem, calling the currval function fails because the system must call the nextval first.

Any ideas????

Thanks,

Caston Received on Sat Mar 11 2000 - 17:31:30 CET