|
Explanation: Because Oracle 9i supports user-defined record sizes larger than 64 KB (see READ SIZE (read buffer size)), the need to break up logical records into multiple physical records is reduced. However, there may still be situations in which you may want to do so. At some point, when you want to combine those multiple physical records back into one logical record, you can use one of the following clauses, depending on your data: CONCATENATE CONTINUE IF Use CONCATENATE when you want SQL*Loader to always combine the same number of physical records to form one logical record. Use CONTINUE IF if the number of physical records to be continued varies. The parameter CONTINUE IF is followed by a condition that is evaluated for each physical record, as it is read. For example, two records might be combined if a pound sign (#) were in byte position 80 of the first record. If any other character were there, the second record would not be added to the first. Incorrect Answer: 1: If the WHEN, NULL IF, or DEFAULT IF clause specifies a position, SQL*Loader compares the clause to the original logical record in the data file. No whitespace trimming is done on the logical record in that case. 2: To load data from one or multiple data files in one SQL*Loader run, use an IN FILE statement for each data file. 5: The TRAILING NULL COLS clause tells SQL*Loader to treat any relatively positioned columns that are not present in the record as null columns. Reference: OCP Oracle 9i Database: Fundamentals II Exam Guide, Rama Velpuri, p. 449-462 Chapter 19: Loading Data into a database
|