The CHAR datatype in SQL*Loader is different from the CHAR datatype in an Oracle 10g table.

Question

Quizplus · Accepted Answer

The CHAR datatype in SQL*Loader is defined as a fixed-length string of characters, while the CHAR datatype in Oracle 10g table is defined as a variable-length string of characters. This means that when data is loaded using SQL*Loader, any trailing spaces in the input file are not removed, whereas in the Oracle database, trailing spaces are automatically removed when data is inserted into a CHAR column.

The CHAR Datatype in SQL*Loader Is Different from the CHAR