how to skip columns in sqlldr

From: <zhangguoping_at_boco.com.cn>
Date: Wed, 19 Mar 2003 15:19:17 +0800
Message-ID: <b595g3$2095$1@mail.cn99.com>

my table is

create table test
(
i integer not null,
j integer not null,
k integer not null
)

my data files is

---

1 2
2 3
3 4

---

i want to use sqlldr to insert into my table 'test' using first column as 'i', and secornd column as 'k', but give the 'j' column a fixed value 9999 just like sql statment below:

insert into table values(1, 9999, 2)
insert into table values(2, 9999, 3)
insert into table values(3, 9999, 4)

how can i skip the 'j' column????? Received on Wed Mar 19 2003 - 01:19:17 CST