Home » RDBMS Server » Server Utilities » sql loader help
sql loader help [message #237093] Fri, 11 May 2007 22:09 Go to next message
Messages: 1
Registered: May 2007
Junior Member

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.
Re: sql loader help [message #237152 is a reply to message #237093] Sat, 12 May 2007 14:07 Go to previous message
Messages: 21148
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.
Previous Topic: How to estimate the size of export dump fille size?
Next Topic: how to access a log file and a bad file?? (merged across forums)
Goto Forum:

Current Time: Sun Aug 20 10:40:43 CDT 2017

Total time taken to generate the page: 0.55267 seconds