Home -> Usenet -> comp.databases.oracle -> statistics with a tree

statistics with a tree

From: (wrong string) érard <morvang_at_mail.club-internet.fr>
Date: 1996/06/12
Message-ID: <4pnc10$gob_at_speedy.grolier.fr>#1/1 







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 :



    
  
  1.   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



GM
Received on Wed Jun 12 1996 - 00:00:00 CEST












Original text of this message