SQL Loader, inserting a nextval from a sequence.
Posted on 2004-10-15
I have several table in oracle which I insert data into, and I want to user sql loader, the basic format of the table are:
client_id constant 123456;
The member_id is a unique member number which is generated from a sequence which I have created:
CREATE SEQUENCE SEQ_MEMBER_ID_TMP
START WITH 468967645
which was created OK.
I just need a control file to insert a list of email and names, and with inserting the member_id and also updating the sequence so that next time it is run the start with value is different as I'm not sure if this will automatically change.