Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL*Loader - No End Of Record Markers
Is any *complete* and thourough documentation on SQLLoader anywhere??
Thanks in advance.
(You can reply by mail if you wish)
Paweł Plichta wrote:
> Hi,
> If you use in control file (name.CTL) word "FIX nn", end of record (line)
> markers is not necessary. (nn- record length must be constant)
>
> Examples
> LOAD DATA
> INFILE "source data" "FIX 80"
> INSERT
> INTO TABLE TableName
> (Column1 POSITION( 1: 7) CHAR
> , Column2 POSITION( 8: 8) CHAR
> ...)
> Pawel
>
> fcs343_at_my-dejanews.com napisał(a) w wiadomości:
> <6ok5gd$e46$1_at_nnrp1.dejanews.com>...
> >Hi
> >
> >I need some help with using SQL*Loader.
> >
> >I need to load a fixed record file with no end of record (line) markers.
> >
> >
> >Francis Sieberhagen
> >
> >-----== Posted via Deja News, The Leader in Internet Discussion ==-----
> >http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>
Received on Sun Aug 02 1998 - 16:10:43 CDT