Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: multilevel hierarchy query

Re: multilevel hierarchy query

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 15 Feb 2005 10:17:15 -0800
Message-ID: <1108491435.738375.46950@o13g2000cwo.googlegroups.com>

Bruce Hensley wrote:
> I don't know how to begin on a query (SELECT statement) to find all
the
> tasks assigned to an arbitrary manager (say, staffID='JSmith') and
her
> organization, that is, assigned to all her underlings, and their
underlings,
> and .... For that matter, I don't even know how to find everyone in
her
> organization (at all levels).
>
> - All individuals have only one manager
> - Tasks are assigned to individuals
> - A manager at any level may have direct reports and sub-managers
>
> The table structure:
>
> tblStaff
> -------------
> staffID
> reportsToID (staffID of direct manager)
>
>
> tblTasks
> --------------
> taskID
> assignedToID (staffID of individual responsible for task)
>
>
> Any help would be greatly appreciated.
>
> Bruce

You can find information about hierarchical queries at http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/queries4a.htm#2053937

URL may wrap.

Regards
/Rauf Received on Tue Feb 15 2005 - 12:17:15 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US