Trailing blanks are not loaded with nondelimited data types unless you specify
BLANKS. If a data field is 9 characters long and contains the value
bbb is three blanks, then it is loaded into the Oracle database as "
DANIEL" if declared as
If you want the trailing blanks, then you could declare it as
':', and add a colon to the data file so that the field is
:. This field is loaded as
"DANIEL ", with the trailing blanks. You could also specify
BLANKS without the
BY clause and obtain the same results.