Database Utilities
ContentsOpens a new window
Opens a new window
Page 361 of 1018

Specifying the Data Type of a Data Field

The data type specification of a field tells SQL*Loader how to interpret the data in the field. For example, a data type of INTEGER specifies binary data, while INTEGER EXTERNAL specifies character data that represents a number. A CHAR field can contain any character data.

Only one data type can be specified for each field; if a data type is not specified, then CHAR is assumed.

"SQL*Loader Data TypesOpens a new window" describes how SQL*Loader data types are converted into Oracle data types and gives detailed information about each SQL*Loader data type.

Before you specify the data type, you must specify the position of the field.

Previous PageOpens a new window
Page 361 of 1018
Next PageOpens a new window