Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: aggregation over two hierarchies

Re: aggregation over two hierarchies

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 22 Feb 2005 22:24:09 +0100
Message-ID: <am8n11lmlf63jrmr72vq0o38j74vj9g3cb@4ax.com>


On 22 Feb 2005 13:00:01 -0800, "navrsale" <navrsalemile_at_yahoo.ca> wrote:

>Query must process each row in JOB_REPORT table and aggregate the
>number of employees when these numbers represent the "history" of
>particular JOB_ID to correct existing value in JOB_REPORT table (to
>"prorate" the number of employees in JOB_REPORT table based on the
>history of given JOB_ID represented inside JOB table).
>
>thanks,
>mile

How much do you pay? Do you realize Usenet is a volunteer business and you can't expect people to sit down for half an hour or more to write your query?

--
Sybrand Bakker, Senior Oracle DBA
Received on Tue Feb 22 2005 - 15:24:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US