OraFAQ Forum: Server Utilities » SQL Loader how to load header line as field

Home » RDBMS Server » Server Utilities » SQL Loader how to load header line as field (9i,10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL Loader how to load header line as field [message #340027]

Mon, 11 August 2008 01:53

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

Report message to a moderator