Re: importing complicated-format data

From: Ed Prochak <prochak_at_my-deja.com>
Date: Thu, 19 Aug 1999 17:18:45 GMT
Message-ID: <7phe95$5tf$1@nnrp1.deja.com>

Sure, just use the SQL*Loader. Your format looks simple enough to do it all in the loader control file. Go for it.

In article <Pine.GSO.4.03.9908181957560.12828-100000_at_trek.CS.ORST.EDU>, Waranun Bunjongsat <bunjonwa_at_trek.CS.ORST.EDU> wrote:
> Hi,
>
> I have a question that. Is there any way or is it possible in
Oracle
> to
> import the data in the following example format ?
>
> 1. three dimensional file format such as,
>
> year month day1 day2 day3 .... day31
> 1970 Jan ........ data ................
> 1970 Feb ........ ................
> ..................................................
> 1970 Dec ......... data .................
> 1971 Jan ........... data ...... ...........
> ........
>
> 2. multi dataset - three dimensions such as,
>
> year month day1 day2 day3 .... day31
> 1970 Jan ........ data1 ................
> 1970 Jan ........ data2 ...............
> 1970 Jan ........ data3 ................
> 1970 Feb ............. data1 .................
> 1970 Feb ........... data2 ................
> ..........
> 1971 Jan .......
>
> Thanks so much in advance,
>
> Regards,
>
> --
> Waranun,
>
>

--
Ed Prochak
Magic Interface, Ltd.
ORACLE services
440-498-3702

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Aug 19 1999 - 12:18:45 CDT