List schema tables in parent/child tree

  • From: "Mohammad Seliem" <mohammad_seliem@xxxxxxxxxxxxxxxxx>
  • To: <Oracle-L@xxxxxxxxxxxxx>
  • Date: Tue, 15 Jun 2010 18:26:49 +0300

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 06-2010