How to list all the dependant tables in correct order

Hi,
Anybody knows how can I get a listing of tables having as a parent  given table ?
Example:
Department -> Employee -> Jobs

Given 'Department' I want the listing to be:

Department

        Employee
                Jobs

This needs to be in correct order ( ie. parent first ). Tried to tree-walk USER_CONSTRAINTS table without success. Maybe a PLSQL program ?

Jan Kucharski
Jan Kucharski
RayCom Systems
mailto:janek_at_raycom-systems.demon.co.uk Received on Sun Sep 28 1997 - 00:00:00 CDT