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
Messages: 8
Registered: March 2008
Junior Member
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.


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.

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
Messages: 20850
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 Oct 24 00:11:22 CDT 2016

Total time taken to generate the page: 0.10279 seconds