RE: where-used-list by TOAD

Phyllis has good advice, but if you're looking for other objects (functions, procedures, etc.) in the DB that use a specific view, then go to the Views tab in Schema Browser, then select the Deps tab on the right.

From: [email protected] [mailto:[email protected]] On Behalf Of Phyllis Helton
Sent: Tuesday, November 08, 2011 10:32 AM
To: '[email protected]'
Subject: RE: [toad] where-used-list by TOAD


It sounds like you want the Object Search utility.  Under the "Search" menu is the option for "Object Search".  You can enter in your view name and what kinds of objects you want to have TOAD search for it and then let it do its magic.

From: [email protected] [mailto:[email protected]] On Behalf Of andy zhang
Sent: Tuesday, November 08, 2011 10:51 AM
To: [email protected]
Subject: [toad] where-used-list by TOAD



Message from: cetzhbo


Hello expert,

       I have a view in the DB, I want to check where this view is used in the DB by TOAD, please tell me how to do this search where-used-list?

Many Thanks,

_______________________________________

Historical Messages


Author: andy zhang
Date: Tue Nov 08 07:51:29 PST 2011
Hello expert,

       I have a view in the DB, I want to check where this view is used in the DB by TOAD, please tell me how to do this search where-used-list?

Many Thanks,
__
_______________________________________