Q : SQL*Loader : Loading on a condition
Appreciate if someone can give me some directions on this.
I get data-files which has a particular identified on the 1st record( header ), based on which I've to load a constant for the 1st column of every row. How do I set in the control file.
O|08-aug-04|1000 -- format( company_id|date|row_count )
john saylor|100|10000 --format( name|emp_id|salary )
larry ellisson|1|10000000 --format( name|emp_id|salary )
... -- 1000 such records
--10 such records
The table I want to load these 2, have these columns
Run_date ( default to sysdate )
Now, all data-files will have only one identifier-record and in the 1st row. So in these examples, I've to set a constant as Oracle or Sun Microsystems based on the 1st record( header ) for every row inserted from that data-file. I need to embed all these in a single control-file to load data-files for different companies.
are you saying you need to look at the
first row, load that company_id for every row
beneath that one?
Click Here to Expand Forum to Full Width