Re: Query to show parent to child tables in order

From: Ban Spam <ban-spam_at_operamail.com>
Date: Sat, 22 Sep 2001 18:53:35 GMT
Message-ID: <Xns912478FAA13F8SunnySD@24.0.3.73>

"DFS" <nospam_at_nospam.com> wrote in
news:ON3r7.6474$W83.618707_at_newsread2.prod.itd.earthlink.net:

> So....
>
> I have an Oracle db with many relations defined between tables. Is
> there a way to construct a query (possibly from DBA_TABLES or
> USER_TABLES or USER_CONS_COLUMNS, etc) that will return a list of
> tables ordered top to bottom from parent to child?
>
>
> Thanks,
> Darryl
>

I suspect that it can be accomplished via SMOP (Small Matter Of Programming) that utilizes a recursive call in the programming language of choice that both can access Oracle & supports recursive calls; such as Perl, PL/SQL, JAVA, etc. Received on Sat Sep 22 2001 - 13:53:35 CDT