The simple answer is NO. but more to the point -
To accomplish what it looks like you wish to do - load a simple
table with columns 1-4 and an empty 5 then use an update to
populate column 5. But - curiousity why are you loading 2
columns that are alike? At least that looks like what you are
doing.
Becca
> I have a question on referencing previously loaded data in
sql loader.
>
> e.g. I have a datafile with these data.
> "A1, "B1", "C1", "D1"
> "A2", "B2", "C2", "D2"
>
> I need to have a control file that would look something like:
> load data
> infile 'test.dat'
> replace
> into table test_table
> fields terminated by "," enclosed by '"'
> (
> column1,
> column2,
> column3,
> column4,
> extracolumn ":column2"
> )
>
> Is it possile for my fifth "extracolumn" reference the value
in "column2"
> without SQL*loader thinking that there is an extra data field
in the
> datafile? When I run the above, I'll get an error message
stating that
> "Column not found before end of record...use TRAILING
NULLCOLS". I don't
> want to use TRAILING NULLCOLS, because if I have a lot of
fields, then I'll
> get "Not all variables are bound."
>
> TIA
>
>
>
>
>
>
--
This answer is courtesy of QuestionExchange.com
http://www.questionexchange.com/showUsenetGuest.jhtml?ans_id=6328&cus_id=USENET&qtn_id=6278
Received on Mon Oct 25 1999 - 20:57:27 CDT
