Re: SQL*Loader And Unique Sequence Numbers

Nick wrote:
>
> 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.

See Sybrand's post, or check out the SEQ / MAX keyword in the sqlloader control file.

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"