Re: how to skip columns in sqlldr

On Wed, 19 Mar 2003 15:19:17 +0800, <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?????
>
>
>

Simply by setting up an appropiate control file which has declarations for the other 2 columns only.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Mar 19 2003 - 04:16:06 CST