Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL Loader, skip records, header and footer
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 - 00:15:40 CST