Tree Query question
Date: 1997/11/10
Message-ID: <3467CCE4.3CF970B5_at_capaccess.org>#1/1
I'm trying to work through a tree query in PL*SQL and getting nowhere.
Can anybody give me a hand with this? E-mail replies are encouraged,
even if you also reply to the newsgroup.
Thanks.
Sincerely,
Data look something like this.
Job Parent Spent
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
10 NULL 100 -- top level has NULL parent
20 10 500 -- child
27 20 700 -- grandchild
32 27 50 -- great grandchild
21 20 200 -- a 2nd branch from job 20
Job Spent_by_Job_&_Progeny
10 1550
20 1450
21 200
27 750
32 50
Received on Mon Nov 10 1997 - 00:00:00 CET