Default: The default is that no NULLIF checking is done.
Purpose
The NULLIF parameter specifies a value that is used to determine whether a field is loaded as a NULL column.
Syntax and Description
NULLIF = "string"
Or
NULLIF != "string"
SQL*Loader checks the specified value against the value of the field in the record. If there is a match using the equal (=) or not equal (!=) specification, then the field is set to NULL for that row. Any field that has a length of 0 after blank trimming is also set to NULL.
Restrictions
None
Example
In the following example, if there are any fields whose value is a period, then those fields are set to NULL in their respective rows.
> sqlldr hr TABLE=employees NULLIF="."