APT_ORACLE_PRESERVE_BLANKS

Set the APT_ORACLE_PRESERVE_BLANKS environment variable to set the PRESERVE BLANKS option in the control file. This preserves leading and trailing spaces.

When PRESERVE BLANKS is not set Oracle removes the spaces and considers fields with only spaces to be NULL values.