How to list all childs elements

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 - 04:42:26 CST