sql loader help [message #237093] |
Fri, 11 May 2007 22:09 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
kreator.1020
Messages: 1 Registered: May 2007
|
Junior Member |
|
|
Hello,
i am writing a code for extraction and processing of data, the problem is i am using sql loader for extraction.
The data file is like :
row 1 abcedfgh 12345
row 2 zyxkmaslklslalsaslaksl
row n jon:dave:ron:shelly:drake
rows 1 to 2 are headers and are not needed, so i am using skip
eg : LOAD DATA (SKIP 2)....
but there is a value in row 1 (12345) that is needed to inserted into the database along with the other values from the below rows, as sql loader does row wise processing specifying position or filler will not help as the loader will take values from the row under consideration so while loading row n it will take :shell and not 12345, please help me on this.
Thanx
|
|
|
Re: sql loader help [message #237152 is a reply to message #237093] |
Sat, 12 May 2007 14:07 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Could you use external table instead of SQL*Loader? It would allow you to process the input file through (PL/)SQL, which might help you doing what you need.
If not, try to load the first line into a separate table and, after the whole loading session is over, extract the desired value (12345 in your example) and - using SQL - update the "main" table.
|
|
|