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