Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Challenging Question
Are you saying the create table is something like:
create table XX
(jan00 date,
feb00 date,
sept04 date);
"Raja Botham" <raja_kommuri_at_yahoo.com> wrote in message
news:ae473522.0409170054.11d94bb2_at_posting.google.com...
> Hello All,
> At the moment, I am working on all the old(legacy) scripts in an
> effort to re-engineer and reuse them to acheive the same business
> needs. On one count, I encountered something very challenging that I
> wanted to share so I can know from you as I am clueless how to begin.
>
> Ok, here is the table
>
> Table XX
> ------------
>
> Jan00 Feb00 ... Sep04 Oct04 Nov04 Dec04 Jan05 Feb05 ...... Dec10
> ----- ----- ----- ----- ----- ----- ----- ----- ------
>
>
> I finished develpoing the package that would calculate the periods and
> their amounts,, however, I am stuck at the point where the values are
> assigned to the columns in table XX.
>
> The output of the package is like this:
>
> Period : Sep04
> Amount : 20
>
> Period : Oct04
> Amount : 30
>
> Period : Nov04
> Amount :30
>
> Period : Dec04
> Amount : 20
>
> The above is just an example,, Sometimes the periods and amounts would
> extend up until Dec10 and sometimes it would just be for a month (say,
> Sep05).
>
>
> Now my task is to insert the values(amounts) to the corresponding
> columns in table XX. So, the table XX should appear like this for this
> data.
>
>
> Jan00 Feb00 ... Sep04 Oct04 Nov04 Dec04 Jan05 Feb05 ...... Dec10
> ----- ----- ----- ----- ----- ----- ----- ----- ------
> 20 30 30 30 25
>
>
> How would I do that ?? I tried using types, records, arrays, dynamic
> sql,, but I am not close enough to make it work. Which is why I would
> like to know if there is any recommended way to go about this.
>
> I look forward to responses based on which I would start working on
> it...
>
>
> Thanks
> Raja
>
> Sometimes the
Received on Fri Sep 17 2004 - 12:35:03 CDT