SQL Loader

From: Ralph Bilger <ralph.bilger_at_uni-tuebingen.de>
Date: Sat, 23 Aug 2003 00:53:49 +0200
Message-ID: <bi66ts$78c$1_at_newsserv.zdv.uni-tuebingen.de>

Hi all,
[Quoted] [Quoted] I am trying to user sqlldr to import data from two files (with different structure) into one Oracle table.
E.g.:
Two data files have to be loaded into table "data":

data1.txt:

pk; txt1; txt2
1;   "a";  "b"
2;   "d"; "e"

data2.txt:
pk; txt3
1; "c"
2; "f"

Table "data" should contain the following information after the load: pk; txt1; txt2; txt3
1; "a" ; "b"; "c"
2; "d"; "e"; "f"

I can read the first data file using sqlldr with the following control file:

LOAD DATA
INFILE 'data1.txt'
INSERT
INTO TABLE data
FIELDS TERMINATED BY ";"
OPTIONALLY ENCLOSED BY '"'
  (pk,
   txt1,
   txt2)

[Quoted] But how can I read the second data file in order to update the table?

Regards,
Ralph Received on Sat Aug 23 2003 - 00:53:49 CEST