Question on SQL Loader

[Chintz]

I have a question on SQL Loader. When loading data using the 'REPLACE' option do the values have to be in the same order as the table definition. For Instance,

create table emp
(
ekey char(3) not null,
ename char(30),
dept char(30)
)

The SQL Loader statement:
LOAD Data
INFILE '/home/data/emp.dat'
REPLACE
into table emp(
ecode FILLER position(3:3) char(1),
e_reason FILLER position(4:5) char(2),
ekey
"(ecode||e_reason)"
ename char(30),
dept char(30)
)

Your input is highly appreciated.

-Chintz

[jmodic]

No, they do not have to be in the same order as there are columns in a table definition.