how to skip columns in sqlldr
From: <zhangguoping_at_boco.com.cn>
Date: Wed, 19 Mar 2003 15:18:04 +0800
Message-ID: <b595dq$2088$1_at_mail.cn99.com>
my table is
1 2
2 3
3 4
[Quoted] 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:
Date: Wed, 19 Mar 2003 15:18:04 +0800
Message-ID: <b595dq$2088$1_at_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
[Quoted] 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 - 08:18:04 CET