1.

How Does One Load Multi-line Records?

Answer»

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.

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


Discussion

No Comment Found

Related InterviewSolutions