Home -> Usenet -> comp.databases.oracle -> sql: hierarchical data - roots with no children

sql: hierarchical data - roots with no children

From: William Leonard <bleonard_at_marcel.gamekeeper.bellcore.com>
Date: 1995/06/08
Message-ID: <3r71d7$d6p_at_athos.cc.bellcore.com>#1/1 






I have an sql stmt that selects hierarchical data 
from a table using 'start with/connect by'.  It does not 
return root rows that have no children (which I want it 
to do).  Any help is appreciated.



sql stmt:




select EQUIP_HOLDER_ID, PARENT_ID , LEVEL
from XBN_EQUIP_HOLDER_T


start with TYPE=0


connect by PARENT_ID = prior EQUIP_HOLDER_ID



Data are in a table, xbn_equip_holder_t.  Bays have shelves
which, in turn, have slots.  The data is represented by:


bay:         1           2         3           4
            / \                    |           |
shelf:    5    6                   7           8
             / | \                           /  \
slot:       9 10 11                         12   13





    
  
  •   Bay 2 is not returned in the result.



    





bleonard_at_gamekeeper.bellcore.com 
Received on Thu Jun 08 1995 - 00:00:00 CEST












Original text of this message