Tree Query question
Date: 1997/11/11
Message-ID: <3468FA05.D745A845_at_capaccess.org>#1/1
I'm trying to work through a tree query in PL*SQL and getting nowhere.
If you are familiar with the Work Breakdown Structure (WBS) concept,
then you quickly understand what I'm doing.
Can anybody give me a hand with this? E-mail replies are encouraged,
even if you also reply to the newsgroup.
Thanks.
Sincerely,
There is no limit to the breadth or depth of the tree, although as a
practical matter I suspect about 10 or 15 levels will be the depth limit
reached and 20 or 30 will be the practical limit for breadth.
I want to construct a report similar to this, but can't see the coding
logic to doing it. Can you point me in the right direction?
Randall
Job Spent_by_Job_&_Progeny
10 1550 -- spent by job 10 and all of its descendents
20 1450 -- " 20 "
21 200 -- " 21. It has no descendents.
27 750 -- " 27 and all of its descendents.
32 50 -- " 32. It has no descendents.
Received on Tue Nov 11 1997 - 00:00:00 CET