1.

How Can You Load Multi-line Records?

Answer»

You can USE the CONCATENATE or CONTINUEIF function to join multiple physical RECORDS to form a single logical record. CONCATENATE is used when SQL*Loader should combine the same number of physical records together to form ONE logical record.
However, CONTINUEIF is used if a condition INDICATES that multiple records should be treated as one. For example, a # CHARACTER in the first column.

You can use the CONCATENATE or CONTINUEIF function to join multiple physical records to form a single logical record. CONCATENATE is used when SQL*Loader should combine the same number of physical records together to form one logical record.
However, CONTINUEIF is used if a condition indicates that multiple records should be treated as one. For example, a # character in the first column.


Discussion

No Comment Found

Related InterviewSolutions