Specifying a NULLIF Clause At the Table Level

You can specify a NULLIF clause at the table level. The syntax is as follows:

NULLIF {=|!=}{"char_string"|x'hex_string'|BLANKS}

The char_string and 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 NO NULLIF at the field level.

See Also: