Hi all,
I've been struggling with this: is there a possibility to select the number of subnodes of a banch? the only way I can think of is this:
select id, desc, (select count(*) from table b connect by prior id=parent_id start with b.parent_id =a.id )
from table a
connect by prior id=parent_id
start with parent_id is null
order siblings by id
but I wonder if this is the way to go or there's a more simple/faster way to do this.
Thanks in advance for any help! This query is executed on Oracle 10gr2 and up!