Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> SQL Loader: Flat file, multiple records per line

SQL Loader: Flat file, multiple records per line

From: dz <dziegl1_at_yahoo.com>
Date: 11 Feb 2002 09:09:32 -0800
Message-ID: <72f8888d.0202110909.31026b3e@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US