Home » SQL & PL/SQL » SQL & PL/SQL » Table hierarchy
Table hierarchy [message #393068] Fri, 20 March 2009 04:13 Go to next message
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 #393074 is a reply to message #393068] Fri, 20 March 2009 04:35 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Then you many need to write custom query using DBA_TABLES, DBA_CONSTRAINS

Babu
Re: Table hierarchy [message #393080 is a reply to message #393068] Fri, 20 March 2009 04:56 Go to previous message
Michel Cadot
Messages: 64129
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Search for this I and others already posted links and scripts to achieve this.

Regards
Michel
Previous Topic: database converting pound sign £ to #
Next Topic: Start autonomous transaction without suspending Main transaction
Goto Forum:
  


Current Time: Wed Dec 07 06:49:07 CST 2016

Total time taken to generate the page: 0.11287 seconds