| Table Usage/Tree Depedencies [message #371974] |
Thu, 28 December 2000 17:17  |
Nicholas Pinakis
Messages: 2
Registered: December 2000
|
Junior Member |
|
|
My previous recent enquiry on this subject refers.
Viewing the "Used By" display of a table in TOAD (schema browser window) provides a display of packages, triggers, views etc. It only provides information at "root" level" to see beyond it is necessary to expand each branch and susequent branches to see the complete structure.
Using the following in SQL Plus (A reply to my initial enquiry)
SELECT *
FROM USER_DEPENDENCIES
WHERE REFERENCED_NAME = 'A TABLE NAME'
The "Root level" (a listing similiar to that in TOAD) is displayed.
Is it possible in SQL Plus to display the tree structure associated from the root similiar to that that can be extracted by manually expanding each of these relationships in TOAD ?.
That is a table may have be used by a view, trigger and package and each of these is subsequently used by others in a tree structure and can this structure be easily displayed.
Thanks in advance for any assistance.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
