Re: statistics with a tree

morvan Gérard wrote:
>
> I have a tree structure, adapted to the CONNECT BY instruction
> like in the reference manual.
>
> I need to compute an ascending average of each node, from the
> bottom of the tree to the root :
>
> a) Tree at to :
>
> 0
> 0 0
> 10 20 5 15 10
>
> b) tree at t1, after computation
>
> 12,5
> 15 10
> 10 20 5 15 10
>
> Have you a solution for this quite basic problem ?
>
> Thanks
>
> GMatest atestst

-- 
John Jones	
Oracle Consultant
jmj22026_at_us1j69.glaxo.com