This content has been marked as final. Show 2 replies
Better is to use external table if you can transfer the file to DB server..1 person found this helpful
Then you can use all the SQL functionalities to filter your data iwth INSERT ALL statement
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.