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 -> tough RECURSIVE QUERY, How?

tough RECURSIVE QUERY, How?

From: NNOOR <Nnoor_at_cris.com>
Date: 1998/01/14
Message-ID: <69in86$j7v@examiner.concentric.net>#1/1

Hi,
Following is the scenerio:

An office can have one or more sub-offices. Each of these sub-offices can have one or more sub-sub-offices...so on. I have implemented this in a single table.
e.g.
PARENT_OFF_ID OFFICE_ID

20               21
20               22
21               23
24               25
23               26
23               27 etc etc

For a given office_id, the query should return either just the office_id passes as the parameter (if it happens to have NO sub offices) or ALL of the LOWEST level offices.

e.g. if passed, 25, it should return 25.

if passed 20, it should return 22,26,27 (notice NOT 21 and 23)
if passed 21, it should return 26,27
if passed 23, it shoudl return 26,27

Can anyone help me with this? Can it be done just thru SQL?

Thanks and Regards,
Nasir (nnoor_at_cris.com) Received on Wed Jan 14 1998 - 00:00:00 CST

Original text of this message

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