
378 13.4 Loading and Transformation
LOAD DATA INFILE . . .
INTO TABLE table1(
col1 CHAR(10),
col2 FILLER CHAR(12),
col3 CHAR(1) TERMINATED BY WHITESPACE)
TRUNCATE FIELDS TERMINATED BY "" TRAILING NULLCOLS
Control File Datatypes
SQL*Loader has a limited datatype set with specific commands for han-
dling different situations for each of the various datatypes, namely strings,
dates, and numbers.
Strings. CHAR[(n)] and VARCHAR[(n)].
DEFAULTIF col1=BLANKS sets to spaces or NULL.
NULLIF col1=BLANKS replace with NULL.
Dates. DATE, TIME, TIMESTAMP, and INTERVALs.
Numbers. Numbers are externally or internally defined.
EXTERNAL { INTEGER | FLOAT | DECIMAL ...