TERMINATED_BY parameter specifies a field terminator that overrides the default.
Syntax and Description
TERMINATED_BY=['char'| x'hex-char' | WHITESPACE]
The field terminator must be a single character. It can be in hexadecimal notation. It can also be whitespace. If
TERMINATED_BY=WHITESPACE is specified, then data is read until the first occurrence of a whitespace character (spaces, tabs, blanks, line feeds, form feeds, or carriage returns). Then the current position is advanced until no more adjacent whitespace characters are found. This allows field values to be delimited by varying amounts of whitespace.
If you use
TERMINATED_BY=WHITESPACE, then null fields cannot contain just blanks or other whitespace because the blanks and whitespace will be skipped and an error may be reported. This means that if you have null fields in the data, then you may have to use another string to indicate the null field and use the
NULLIF parameter to indicate the
NULLIF string. For example, you could use the string
"NoData" to indicate a null field and then insert the string
"NoData" in the data to indicate a null field. Specify
NULLIF="NoData" to tell SQL*Loader to set fields with the string
In the following example, fields are terminated by the | character.
> sqlldr hr TABLE=employees TERMINATED_BY="|"