List schema tables in parent/child tree

From: Mohammad Seliem <mohammad_seliem_at_siliconexpert.com>
Date: Tue, 15 Jun 2010 18:26:49 +0300
Message-ID: <019201cb0c9f$2d4a2b80$87de8280$_at_com>



Could you please help me by providing a SQL that list schema tables in parent/child tree.  

Example:

TableName Level

TAB1                      1

TAB2                      2

TAB3                      2

TAB4                      3

 

Thanks,

Mohamed Seliem  

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jun 15 2010 - 10:26:49 CDT

Original text of this message