| SQL*Loader Multiple Rows [message #117501] |
Wed, 27 April 2005 10:29  |
lneumann
Messages: 1
Registered: April 2005
Location: Nashville
|
Junior Member |
|
|
Consider the following data.
Date Check Amount
01-JAN-O5 0001 1000
01-JAN-05 0002 1514
04-JAN-05 0003 2052
Can I use a SQL*Loader to load this data into a table that will produce the following results?
REC ID DATE CHECK AMOUNT
01 31-JAN-05 Null Null
02 01-JAN-05 0001 1000
02 01-JAN-05 0002 1514
02 04-JAN-05 0003 2052
What I want to do is to load the 3 detail rows (easy enough) but also create a single header row in the same table.
[Updated on: Wed, 27 April 2005 10:30] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
