Re: help for load data

From: <no_at_promaxis.com>
Date: Wed, 09 Feb 2000 21:21:41 GMT
Message-ID: <FTko4.806$L3.1963178@news.magma.ca>

with a fixed number of fields just use
CONCATENATE n

example

LOAD DATA
INFILE 'sample.dat'
CONCATENATE 10
INTO TABLE sample

IF there is a a variable number of fields use CONTINUEIF
Check Server utilities Book SQL loader case studies Case 4

basicly this will combing the lines in the source file into one line.

Filippo Cestari wrote in message <389FE310.AC562246_at_unina.it>...
>hi all,
>
>i have a file xxx.dat with this structure :
>
>name_field1:field1
>name_field2:field2
>............
>...........
>name_fieldn:fieldn
>þþþþþþþþþ <----- new record
>name_field1:field1
>name_field2:field2
>............
>...........
>name_fieldn:fieldn
>þþþþþþþþþ
>
>The release of Oracle Server is 8.0.5 .
>Someone can send me the istruction of the Control file for to use
>sql-loader ?
>Thank's in advance for any help.
>
>Filippo Cestari
>
>
>
Received on Wed Feb 09 2000 - 15:21:41 CST