This content has been marked as final. Show 2 replies
You cannot compare 2 fields with the WHEN clause in an SQL*Loader control file.
only literal values as defined by the syntax:
As already suggested, you would be better to load your data using an external table where you can apply any conditions you want during your SQL query that is fetching the data.