Re: How to list all the dependant tables in correct order

From: Jomarlen <jomarlen_at_aol.com>
Date: 1997/09/30
Message-ID: <19970930002101.UAA00967@ladder01.news.aol.com>#1/1

If you visit my web site at http://members.aol.com/jomarlen and link to my Oracle utilities page you'll find a view I created called ALL_FK_CONSTRAINTS.

This view lists parent and child tables and a tree walk should give you what you want.

Regards
John

---

John C. Lennon
Utility Partners Inc.
4300 West Tropicana Blvd LVO-UPL
Las Vegas NV 89103

FOR UTILITY PARTNERS EMPLOYMENT
OPPORTUNITIES VISIT www.utilpart.com

e-mail: jomarlen_at_aol.com
Web Site: http://members.aol.com/jomarlen/

The views expressed in this message
are those of the author and not
necessarily those of U.P. Inc.
and/or its employees.

---

>Subject: Re: How to list all the dependant tables in correct order
>From: "Dan Clamage" <clamage_at_mime.dw.lucent.com>
>Date: Mon, 29 Sep 1997 21:13:42 GMT
>Message-id: <01bccce2$eb70e190$54110b87_at_clamagent>
>
>You can write a PL/SQL program to walk through the USER_CONSTRAINTS view
>following all the foreign key references (where constraint_type = 'F'). Is
>this what you mean?
>-djc
>
>Jan Kucharski <janek_at_raycom-systems.demon.co.uk> wrote in article
><04lVtBAw7qL0Ew05_at_raycom-systems.demon.co.uk>...
>> Hi,
>> Anybody knows how can I get a listing of tables having as a parent
>> given table ?
>> Example:
>> 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 ?
>
>
>
>
>
>
>
Received on Tue Sep 30 1997 - 00:00:00 CDT