I am inthe process of loading datas from flat file to Oracle table.
When a character column is loaded with values of spaces then oracle is
interpreting as null.
create table load_test2(c char(5));
the sqloader control file is written as
into table load_test2
c position(1:5) char
The data file is
The second record is taken as null but it is 5 spaces.
Can anyone can give me suggestions what changes i have to make in the Sqlloader file so that spacel is not interpreted as null by oracle.
I am in need to use position(1:5) clause.