Home » SQL & PL/SQL » SQL & PL/SQL » Table hierarchy
Table hierarchy [message #393068] Fri, 20 March 2009 04:13 Go to next message
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.

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?

Re: Table hierarchy [message #393074 is a reply to message #393068] Fri, 20 March 2009 04:35 Go to previous messageGo to next message
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

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

Re: Table hierarchy [message #393080 is a reply to message #393068] Fri, 20 March 2009 04:56 Go to previous message
Michel Cadot
Messages: 65079
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.

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

Current Time: Thu Jul 20 15:47:23 CDT 2017

Total time taken to generate the page: 0.09934 seconds