SQL Developer Search

[mcauliff]

Is it possible to search in SQL Developer for where a view or packages is used?

An example, view is view_a, I want to know all objects where view_a is mentioned.

is this possible in SQL Developer search function? How?

 

[carp]

You can query the dba_dependencies view to find that information.

 

[Dagon]

SQL*Developer may have a tab that shows dependencies - TOAD does. The only thing that might not get picked up by dba_dependencies are any uses of the view in dynamic SQL. For this you could resort to dba_source.

For Oracle-related work, contact me through Linked-In.

 

[mcauliff]

Thank you for the reply

SQL Developer does have a feature that will display dependencies.

It is also great to know how to do it with SQL also.

I'm able to do the research that I required.

 

[SantaMufasa]

McAuliff,

Both Carp and Dagon earned a

, I believe.

Mufasa
(aka Dave of Sandy, Utah, USA)
“People may forget what you say, but they will never forget how you made them feel.