Re: SQL*Loader And Unique Sequence Numbers

Just put a trigger on the table the data is going into, and have it assign a sequence number in the ordinary way
select <sequencename>.nextval into :new.<column> from dual;

Hth,

Sybrand Bakker, Oracle DBA

"Nick" <nickb_at_kubota.co.uk> wrote in message news:3aa66708_at_tahiti.alcom.co.uk...
> Hi All.
>
> I am in the process of creating a marketing database app which will
> eventually 'load' (variable-length) customer data from numerous excel/csv
> files.
>
> For this, I think I need to create a control file that sets a column (in
> this case 'CUSTOMER_CODE') to a unique SEQUENCE number.
>
> Could someone please suggest how this is achieved?
>
> Many thanks,
>
> Nick.
>
>
>
Received on Thu Mar 08 2001 - 01:12:47 CST