Oracle : one load multi-line records

One can create one logical record from multiple physical records using one of the following two clauses:

. CONCATENATE: - use when SQL*Loader should combine the same number of physical records together to form one logical record.

. CONTINUEIF - use if a condition indicates that multiple records should be treated as one. Eg. by having a '#' character in column 1.