Re: Query to show parent to child tables in order

From: DFS <nospam_at_nospam.com>
Date: Sun, 23 Sep 2001 04:39:13 GMT
Message-ID: <RHdr7.9101$Hx1.849909@newsread1.prod.itd.earthlink.net>

Thanks Tom.....I'll give it a try.

Darryl

"Thomas Kyte" <tkyte_at_us.oracle.com> wrote in message news:9oiusk0k5n_at_drn.newsguy.com...
> In article <ON3r7.6474$W83.618707_at_newsread2.prod.itd.earthlink.net>, "DFS"
> says...
> >
> >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
> >
> >
> >
> >
> >
>
> see
>

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:661009003 696
> for one method (might have to update that for 9i since you can join a
connect by
> there ;)
>
> --
> Thomas Kyte (tkyte@us.oracle.com) http://asktom.oracle.com/
> Expert one on one Oracle, programming techniques and solutions for Oracle.
> http://www.amazon.com/exec/obidos/ASIN/1861004826/
> Opinions are mine and do not necessarily reflect those of Oracle Corp
>
>
Received on Sat Sep 22 2001 - 23:39:13 CDT