RE: List schema tables in parent/child tree

From: Daniel Fink <>
Date: Tue, 15 Jun 2010 10:54:53 -0500
Message-ID: <>


How do you define a parent table and a child table? One could assume that this is defined by Referential Integrity constraints (in this case you should look at dba_constraints and work out the logic and read up on connect by to work out the sql). But in the absence of an example of data and desired output or a good requirements definition, we are left to guess and speculate.

And it is not good to guess and speculate...

Daniel Fink

  • Original Message ------- On 6/15/2010 3:26 PM Mohammad Seliem wrote: Could you please help me by providing a SQL that list schema tables in parent/child tree.


TableName Level

TAB1                      1

TAB2                      2

TAB3                      2

TAB4                      3



Mohamed Seliem  

-- Received on Tue Jun 15 2010 - 10:54:53 CDT

Original text of this message