Home » RDBMS Server » Server Utilities » SQL Loader how to load header line as field (9i,10g)
SQL Loader how to load header line as field [message #340027] Mon, 11 August 2008 01:53 Go to next message
nooruls143
Messages: 8
Registered: March 2008
Junior Member
Hi,
I have a semi-colon seperated file I need to load to oracle using sql loader. It contains a header line which contains date and time. I want to include this time value as a column for each row that is loaded subsequently after the header file. Any ideas how to do this.

Example:
20080106;1200280801;400;Motorola
;;;;;;;;001500083026430;;;I325;R1A.01.08;364YHY8ZP1;29493679;;;;;;;;;;
;;;;;;;;001500083061430;;;I325;R1A.01.08;364YHY8ZN8;61951819;;;;;;;;;;
;;;;;;;;001500082922430;;;I325;R1A.01.08;364YHY8ZLL;24978001;;;;;;;;;;


I want to include the top first field "20080106" as a column-field when it loads all the other rows to identify the record belonging to that date.

Thanks,
Noorul
Re: SQL Loader how to load header line as field [message #340038 is a reply to message #340027] Mon, 11 August 2008 02:34 Go to previous message
Littlefoot
Messages: 20894
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Take a look at this recent thread; perhaps you'll get an idea.
Previous Topic: question about access & oracle
Next Topic: clob infile taking long time to load few records
Goto Forum:
  


Current Time: Mon Dec 05 09:14:35 CST 2016

Total time taken to generate the page: 0.09609 seconds