Home » RDBMS Server » Server Utilities » sql loader help
sql loader help [message #237093] Fri, 11 May 2007 22:09 Go to next message
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
Littlefoot
Messages: 21823
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: External Table - BADFILE overwrites every time.
Next Topic: migrate from 10g to 9i, with LOB objects ??
Goto Forum:
  


Current Time: Wed Dec 25 12:00:30 CST 2024