Re: How to list all childs elements

From: Michael O'Shea <michael.oshea_at_tessella.com>
Date: 3 Jan 2007 03:39:30 -0800
Message-ID: <1167824370.052895.305160@k21g2000cwa.googlegroups.com>

Philip Greenspun has a very resource for learning about these types of hierarchical queries.

The URL is http://philip.greenspun.com/sql/trees.html

The site even includes code for your specific requirement.

Regards
Mike

TESSELLA Michael.OShea_at_tessella.com

__/__/__/  Tessella Support Services plc
__/__/__/  3 Vineyard Chambers, ABINGDON, OX14 3PX, England
__/__/__/  Tel: (44)(0)1235-555511  Fax: (44)(0)1235-553301

www.tessella.com Registered in England No. 1466429

tomec_at_obywatel.pl wrote:
> Hello,
>
> I have a table with 3 fields (name,id,child_id) where id is parent id
> and child_id is its child id.
> For example:
>
>
> name id child_id
> mary 1 12
> henry 12 3
> john 5 4
> andrew 3 17
>
>
> How to list all childs of mary (12,3,17 ) using sql/ pl/sql?
>
> Thanks in advance
> Best Regards
> AGent
Received on Wed Jan 03 2007 - 05:39:30 CST