Re: how to skip columns in sqlldr

[Quoted] you could read the data into a temporary table, use SQL to copy the data you want then drop the temporary table, perhaps something like:

insert into test select p,9999,q from temp_table;

where p and q are the two columns in temp_table.

Dave.

zhangguoping_at_boco.com.cn wrote:
> 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?????
>
>

-- 
--
Email munged to avoid spam.  Reverse bits of it to email directly.