10 SQL*Loader Field List Reference

The field-list portion of a SQL*Loader control file provides information about fields being loaded, such as position, data type, conditions, and delimiters. More information about these aspects of SQL*Loader control file is provided in the following topics:

• Field List Contents

• Specifying the Position of a Data Field

• Specifying Columns and Fields

• SQL*Loader Data Types

• Specifying Field Conditions

• Using the WHEN_ NULLIF_ and DEFAULTIF Clauses

• Loading Data Across Different Platforms

• Byte Ordering

• Loading All-Blank Fields

• Trimming Whitespace

• How the PRESERVE BLANKS Option Affects Whitespace Trimming

• Applying SQL Operators to Fields

• Using SQL*Loader to Generate Data for Input