Re: Sqlloader: All database in one single plain text file
From: Ralf <db.2.gemini_at_spamgourmet.com>
Date: 26 Feb 2004 02:15:55 -0800
Message-ID: <51a9e702.0402260215.58e2e38f_at_posting.google.com>
Date: 26 Feb 2004 02:15:55 -0800
Message-ID: <51a9e702.0402260215.58e2e38f_at_posting.google.com>
Hallo, BadMan,
look there to find the answer:
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:3516903603571
best regards
Ralf
-- loktai_at_engineer.com (BadMan!) wrote in message news:<8e5d4aee.0402251004.5fbc6c7f_at_posting.google.com>...Received on Thu Feb 26 2004 - 11:15:55 CET
> Hi all,
>
> I'm trying to use sqlloader to import a database with multiple
> different tables which has been exported to one single plain text
> file. No fixed lenght. Let's say database.txt is something like
>
> fruits,orange,orange
> fruits,banana,yellow
> fruits,pear,green
> users,John Doe,25,34,26th upper street,0, 12-2-2003
> users,Fred Flinstone, 24,5,14th Downing Lane,1,1-7-2002
>
>
>
> żIs it possible to try an approach based on WHEN statements? I mean:
>
> LOAD DATA
> INFILE database.txt
> FIELDS TERMINATED BY ','
> WHEN (first field is 'fruits')
> (name, color)
> WHEN (first field is 'users')
> (name, age, visits, address, active, since)
>
> I only whant to know if it is possible or not, but will wellcome
> advice in ctl file sintax.
>
> Thanks in advance and best regards