If the table definition has column defaults, use the DEFAULTIF clause in the controlfile fields.
Othewise code something like this:
Code:LOAD DATA -- etc -- INTO TABLE -- etc -- (... , fieldx "NVL(:fieldx,'{default value here}')" , ...![]()
|
Results 1 to 3 of 3
Thread: SQL Control fileThreaded View
|
Click Here to Expand Forum to Full Width |