Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Query to show parent to child tables in order

Query to show parent to child tables in order

From: DFS <nospam_at_nospam.com>
Date: Sat, 22 Sep 2001 17:22:54 GMT
Message-ID: <ON3r7.6474$W83.618707@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
Received on Sat Sep 22 2001 - 12:22:54 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US