I tried to load text file to Oracle database using sqlldr. Here is the control file:
INTO TABLE pager_data
WHEN c1 = 'Record_E' and phonenum <> ' ' and capnum <> ' '
fields terminated by ","
charge decimal external "ROUND(:charge*1.15,2)",
phonenum char nullif phone_num=blanks "REPLACE(:phone_num,'-')",
capnum char nullif capnum=blanks,
In the condition, If BOTH phonenum AND capnum are NULL, then these records should be skipped, but log shows sql loader skips records if EITHER condition matches. Anyone know why? Thanks for your help.