SQL*Loader (Sqlldr) Translates Blanks into a NULL
(Doc ID 365040.1)
Last updated on APRIL 03, 2020
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199 [Release 8.1.7 to 11.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
This problem can occur on any platform.
You use SQL*Loader to insert data into a table. When the field in the data file contains blanks, NULLs are being inserted for that field within the database. This behavior is visible within the 9i, 10g and 11g versions.
The following illustrates the issue:
Create a table
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document