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

From: Dan Clamage <clamage_at_mime.dw.lucent.com>
Date: 1997/09/29
Message-ID: <01bccce2$eb70e190$54110b87@clamagent>#1/1

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 Mon Sep 29 1997 - 00:00:00 CDT