You can specify a
NULLIF clause at the table level. The syntax is as follows:
hex_string values must be enclosed in either single quotation marks or double quotation marks.
This specification is used for each mapped character field unless a
NULLIF clause is specified at the field level. A
NULLIF clause specified at the field level overrides a
NULLIF clause specified at the table level.
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.
If you do not want the default
NULLIF or any other
NULLIF clause applied to a field, you can specify
NULLIF at the field level.
"Using the WHEN_ NULLIF_ and DEFAULTIF Clauses" for more information about specifying a NULLIF clause at the field level