Re: SQL Loader, skip records, header and footer
From: N.V.Dev <devnv_at_yahoo.com>
Date: 17 Mar 2003 22:15:40 -0800
Message-ID: <da85daf0.0303172215.acd3573_at_posting.google.com>
Date: 17 Mar 2003 22:15:40 -0800
Message-ID: <da85daf0.0303172215.acd3573_at_posting.google.com>
Hi,
Use the "SKIP n" keyword, where n = number of logical rows to skip. Look at this example:
LOAD DATA
INFILE *
INTO TABLE load_positional_data
SKIP 5
( data1 POSITION(1:5),
data2 POSITION(6:15)
)
BEGINDATA
11111AAAAAAAAAA
22222BBBBBBBBBB
for more details point to http://www.orafaq.com/faqloadr.htm#SKIP
Hope this helps
Dev
"Michel R." <michelr_at_hydro.qc.ca> wrote in message news:<gKpda.23874$eD6.223410_at_wagner.videotron.net>...
> Hello all,
>
> Is it possible to also tell SQL Loader to skip a certain number of lines at
> the end of the data file, like we can tell SKIP=1 for the start of the file?
>
> Michel.
Received on Tue Mar 18 2003 - 07:15:40 CET