Messy SQLLDR question
Date: Sun, 24 May 1998 09:21:27 -0600
Message-ID: <6k9dtn$jsp$1_at_news1.rmi.net>
[Quoted] I need to load a table from a comma-delimited file using SQLLDR. However, the input file consists of data that must load into separate rows in the table, e.g.,
ID,TYPE,val1,val2,val3,val4
where ID is a numeric identifier, type is a sub-identifier, and the valx statements are numeric values.
The table looks like
create table SUMTABLE
(
ID NUMERIC,
TYPE NUMERIC,
VALUE NUMERIC);
I understand that in SQLLDR this is going to take 4 separate statements of
the form
load data
into table SUMTABLE Fields terminated by ','
(ID,TYPE,VALUE)
into table SUMTABLE Fields terminated by ','
(ID POSITION (1),TYPE,VALUE POSITION (???))
etc.
What I can't figure out is how to tell SQLLDR to use the relative field, rather than a fixed column position, in the second "into table" statement. If I use POSITION (3), then it loads data starting at the third byte of the data record, rather than the third relative field.
Any ideas??? I'm sure that I'm overlooking the obvious.
Thanks,
Rog
-- roger_at__delete_this_to_reply_.martech.comReceived on Sun May 24 1998 - 17:21:27 CEST