Table hierarchy [message #393068] |
Fri, 20 March 2009 04:13  |
ora_2007
Messages: 430 Registered: July 2007 Location: Mumbai
|
Senior Member |
|
|
I have user which consists of 150 tables.
I want to hierarchical list of tables in such as way that referential tables will be displayed first then base tables display.
e.g.
Dept and Emp table.
Emp(dept_id) references to Dept(dept_id)
So I should display in following manner
1. Emp
2. Dept
How can i get that list?
Thanks
|
|
|
|
Re: Table hierarchy [message #393080 is a reply to message #393068] |
Fri, 20 March 2009 04:56  |
 |
Michel Cadot
Messages: 68733 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
Search for this I and others already posted links and scripts to achieve this.
Regards
Michel
|
|
|