List of Examples

3-1 Loading Data in Fixed Record Format

3-2 Loading Data in Variable Record Format

3-3 Loading Data in Stream Record Format

5-1 Sample Control File

5-2 CONTINUEIF THIS Without the PRESERVE Parameter

5-3 CONTINUEIF THIS with the PRESERVE Parameter

5-4 CONTINUEIF NEXT Without the PRESERVE Parameter

5-5 CONTINUEIF NEXT with the PRESERVE Parameter

6-1 Field List Section of Sample Control File

6-2 DEFAULTIF Clause Is Not Evaluated

6-3 DEFAULTIF Clause Is Evaluated

6-4 DEFAULTIF Clause Specifies a Position

6-5 DEFAULTIF Clause Specifies a Field Name

7-1 Loading Column Objects in Stream Record Format

7-2 Loading Column Objects in Variable Record Format

7-3 Loading Nested Column Objects

7-4 Loading Column Objects with a Subtype

7-5 Specifying Attribute Nulls Using the NULLIF Clause

7-6 Loading Data Using Filler Fields

7-7 Loading a Column Object with a User-Defined Constructor That Matches
the Attribute-Value Constructor

7-8 Loading a Column Object with a User-Defined Constructor That Does Not
Match the Attribute-Value Constructor

7-9 Loading a Column Object with a User-Defined Constructor That Does Not
Match the Attribute-Value Constructor by Using a SQL Expression

7-10 Loading an Object Table with Primary Key OIDs

7-11 Loading OIDs

7-12 Loading an Object Table with a Subtype

7-13 Loading Real REF Columns

7-14 Loading Primary Key REF Columns

7-15 Loading LOB Data in Predetermined Size Fields

7-16 Loading LOB Data in Delimited Fields

7-17 Loading LOB Data in Length-Value Pair Fields

7-18 Loading Data Using BFILEs: Only Filename Specified Dynamically

7-19 Loading Data Using BFILEs: Filename and Directory Name Specified
Dynamically

7-20 Loading LOB DATA with One LOB per LOBFILE

7-21 Loading LOB Data Using Predetermined Size LOBs

7-22 Loading LOB Data Using Delimited LOBs

7-23 Loading LOB Data Using Length-Value Pair Specified LOBs

7-24 Loading a VARRAY and a Nested Table

7-25 Loading a Parent Table with User-Provided SIDs

7-26 Loading a Child Table (the Nested Table Storage Table) with User-Provided
SIDs

9-1 Setting the Date Format in the SQL*Loader Control File

9-2 Setting an NLS_DATE_FORMAT Environment Variable