Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: how to skip columns in sqlldr

Re: how to skip columns in sqlldr

From: Aitor Cuartango <acuartango_at_terra.es>
Date: Wed, 19 Mar 2003 07:52:06 GMT
Message-ID: <GkVda.1432533$Ye7.9310979@telenews.teleline.es>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US