Re: SQL Loader: How to skip fields?

[Quoted] You can specify the column as a FILLER and sqlldr will skip that column. For example:

INTO TABLE MYTEST
(
col1 CHAR(20),
col2 FILLER CHAR(30),
col3 CHAR(20)
)

col1 and col3 must exist in the table but col2 is ignored.

>> > Christoph Meyer wrote:
>> >
>> > > Hi!
>> > >
>> > > I'm trying to load a data file with each record containing 3 fields
>(col_A,
>> > > col_B, col_C) using SQL*Loader.
>> > > The table in the database, however, contains 2 fields only (field1,
>field2)
>> > > What's the syntax for the loader script to load:
>> > > col_A into field1,
>> > > col_C in field2 and
>> > > skip col_B?
>> > >
>> > > Any suggestions? Thanks in advance.
>> > > Christoph Meyer
>> > >
>> > > ---
>> > > Please remove [nospam] before replying.
>
>
Received on Wed Feb 02 2000 - 02:31:50 CET