Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: importing complicated-format data
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