Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> SQL Loader: Flat file, multiple records per line
What would be the best way to go about loading a flat text file into
an Oracle table using SQL Loader where the format is as follows:
report heading
name account address name account address name account address name account address name account address name account address name account address name account address report heading name account address name account address name account address name account address name account address name account address name account address name account address
Each line in the file actually contains two records and the report is broken up into two sections per "page". Would it be better to go through the file twice, once per "side" or... go through the file only once and somehow break each line into two records? If someone could post a simple example of how to do this, I would appreciate it.
Thanks,
dz
Received on Mon Feb 11 2002 - 11:09:32 CST
![]() |
![]() |