Re: how to skip columns in sqlldr

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?????
>
>
>
>

I think its possible to do this:

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

bye! Received on Wed Mar 19 2003 - 01:52:06 CST