Example
SQL*LOADER performs transformations such as:
DATE 'DD-MMM-YYYY' converts from a value such as 23-Mar-1999 to an Oracle date.
"TO_NUMBER(:COL)" converts the data to a number
"NVL(TRIM(:COL),0)" trims leading and trailing white characters and inserts zero if null.
After Load Transformations
'After' transformations will initiate a pass of the load table after the load has occurred. They allow manipulation of the load table columns using the database and SQL functions.