| sql loader help [message #237093] |
Fri, 11 May 2007 22:09  |
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  |
 |
Littlefoot
Messages: 21811
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
