By using the POSITION
parameter with multiple INTO TABLE
clauses, data from a single record can be loaded into multiple normalized tables. See case study 5, Loading Data into Multiple Tables, for an example. (See "SQL*Loader Case Studies" for information about how to access case studies.).