: Useful for fixed-width files or fields that might contain spaces. column_name NULLIF (column_name = BLANKS) Use code with caution. Copied to clipboard 3. Using the DEFAULTIF Clause
By default, if a field in the data file is empty (contains no data between delimiters), SQL*Loader attempts to load it as a . However, if the column in the database has a NOT NULL constraint, the record will be rejected and moved to the .bad file. 2. Using the NULLIF Clause Handle Null Values In Sql Loader
: Useful if your source system uses a placeholder like "N/A" or "0". column_name NULLIF (column_name = "N/A") Use code with caution. Copied to clipboard : Useful for fixed-width files or fields that
The NULLIF clause is the most common way to explicitly define when a field should be treated as null. It tests a condition; if true, it sets the column to NULL. Using the DEFAULTIF Clause By default, if a
If your data file has records where the last few columns are often empty, SQL Loader might throw an error because it expects more delimiters. Use the TRAILING NULLCOLS clause at the table level to tell SQL Loader to treat any missing relative fields at the end of a record as nulls.
A keyword used with NULLIF to identify fields containing only whitespace.