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.
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-lReceived on Tue Jun 15 2010 - 10:26:49 CDT