Home » RDBMS Server » Server Utilities » SQL*Loader - multiple line load - HELP!!
SQL*Loader - multiple line load - HELP!! [message #368242] Tue, 10 October 2000 07:13 Go to next message
Martin Johansson
Messages: 11
Registered: October 2000
Junior Member
Hi..

I want to load multiple lines in a file a ONE row in the database. Different rows in the file should be loaded into different columns in the database.
Example:

File to load:

Value1 -> to line1 column1 in the DB
Value2 -> to line1 column2 in the DB
Value3 -> to line1 column3 in the DB
Value4 -> to line1 column4 in the DB

Please help

/Martin
Re: SQL*Loader - multiple line load - HELP!! [message #368243 is a reply to message #368242] Tue, 10 October 2000 11:37 Go to previous messageGo to next message
Bala
Messages: 205
Registered: November 1999
Senior Member
Hi,

Do you have a fixed length or variable length records.
If you have fixed length you can ask sqlldr to continue till the end of physical record(in your ex its end of 4th line)

Or you can load the data into a work table with two columns value and id.
like this:

load data
infile c:\data.txt
append into work_table
(value ,
id sequence(1, max))

The id column will have serial numbers from 1 to max_no_of_records.
And write a proc to insert the data from work_table to the perm_table.
(load value into col1 where id = 1, 5, 9 etc....)

Good luck
Bala
Re: SQL*Loader - multiple line load - HELP!! [message #368247 is a reply to message #368242] Fri, 13 October 2000 16:15 Go to previous message
Bala
Messages: 205
Registered: November 1999
Senior Member
Hi ,
This is a followup of my followup.

Actually if you have fixed number of physical
records to form a logical, you can use concatenate n command.

in control file
load data
infile ......
concatenate 4

Hope you would have already figure that out,
in case.....

Thanks
Bala
Previous Topic: SQLLoader
Next Topic: How to use SQL*Loader to load binary data
Goto Forum:
  


Current Time: Thu Mar 28 06:04:34 CDT 2024