Re: question on getting cumulative % and other

Hongjiew wrote:
>
> Dear friends:
>
> I try to accomplish the following:
>
> table
>
> department revenue perctage
> 1 100 0.10
> 2 200 0.20
> 3 400 0.40
> ...
> I want to write a simple query to generate the cumulative percentage,
>
> In other words,
> department revenue cum
> 1 100 0.10
> 2 300 0.30
> 3 700 0.70
> ...
>
> Also, I like to create a triger on a transaction table such that it will invoke
> a procedure which in term is updating a summary table based on the transaction
> table.
>
> Please help.
>
> Thanks.
>
> hongjiew_at_aol.com

From 8.1.6, take a look at analytic functions ... You can pretty much achieve any form of statistical method with these...

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"