Re: SQL*LOADER using Sequence No's

If the need of sequence control isn't vital, you can code

REC_SEQ_ID sequence(max) .

If it is,

REC_SEQ_ID "myseq.nextval".

-- 
 Alexander I.Doroshko, aid_at_grant.kharkov.ua
 * Bank "Grant", Kharkov, Ukraine

Jamie Grant <jamieg_at_22nra.freeserve.co.uk> wrote in article
<7qh3ms$iia$1_at_news6.svr.pol.co.uk>...


: Can anyone help me with the following ?

: 

: I am using sqlldr73 to load a flat acsii file (.csv) into an Oracle


Table.


: 

: I've managed to load the data ok, but I need to generate a unique


Sequence


: No for every record loaded.

: 

: Is it possible to use an SQL function and generate the Sequence No


through


: the sql*loader.

: 

: I cant use the defined loader sequence function as I may load data


several


: times a day

: & want an Oracle sequence to control the number generated.

: 

: I've tried the below syntax but cant get it to work:

: 

: REC_SEQ_ID    Number    "Select (myseq.nextval to :REC_SEQ_ID)",

: 

: Am I on the right track ? or barking in the wrong forest ?

: 

: Any help or clues appreciated,    Jamie.