OraFAQ Forum: SQL & PL/SQL » How to select recusrsively in an sql statement

Home » SQL & PL/SQL » SQL & PL/SQL » How to select recusrsively in an sql statement

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to select recusrsively in an sql statement [message #23350]

Tue, 03 December 2002 22:45

rao
Messages: 25
Registered: July 1999

Junior Member

Hi,
I have a requirement like this.
In an organization, I have a supervisor to whom 10 people are reporting, these 10 are supervisors for another 100 people and it goes like this. a simple hierarchial structure.
In my query if I give the top supervisor, i want all the people under him and sub level till the last level, where no more supervisors

Thanks and Best regards,
Rao

Report message to a moderator

Re: How to select recusrsively in an sql statement [message #23351 is a reply to message #23350]

Tue, 03 December 2002 23:02

Samir
Messages: 32
Registered: April 2002

Member

Go in for a self join type of a structure.

select * from tablea A, tablea B
where A.persontype = "supervisor" and b.persontype = "reports to supervisor"

Maybe if you can give the column names I will be able to help out better

Report message to a moderator