importing complicated-format data

From: Waranun Bunjongsat <bunjonwa_at_trek.CS.ORST.EDU>
Date: Wed, 18 Aug 1999 19:59:18 -0700
Message-ID: <Pine.GSO.4.03.9908181957560.12828-100000_at_trek.CS.ORST.EDU>



Hi,

    I have a question that. Is there any way or is it possible in Oracle to
[Quoted] 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,
Received on Thu Aug 19 1999 - 04:59:18 CEST

Original text of this message