Using sqlldr for variable length records

From: Peter W. Flur <flur_at_eecom.gatech.edu>
Date: 15 Mar 1994 16:51:39 GMT
Message-ID: <2m4p2s$gtd_at_hardy.ee.gatech.edu>


I have a file of the format:

Name1 A1 B1 C1 D1
Name2 A2 B2 C2 D2 E2 F2
Name3 A3
Name4 A4 B4 C4
...

Each line is a person, and there can be any number of columns, each of which is a record that needs to go into a table. There will be a master-detail table relationship where the Names (and associated information) go into the master table, and all the columns go into the detail with the key referenced to the master.

Is there a way to combine some of the examples in the Loader manual to do this? They talk about loading into multiple tables. They also talk about loading multiple logical records from a physical record, but what I am describing is a little bit different from both of those...

Thanks for any help.
Peter

-- 
     Peter Flur, Research Engineer - School of ECE, Georgia Tech
       E-MAIL: peter.flur_at_ee.gatech.edu PHONE: (404) 853-9355
Received on Tue Mar 15 1994 - 17:51:39 CET

Original text of this message