Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Query to show parent to child tables in order
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:661009003696
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 CorpReceived on Sat Sep 22 2001 - 16:12:52 CDT