System View - Possible to Identify Tables within User Views/Functions?

[ihda]

Using system views, can the table be identified within user written views and functions?

Example:
I have functions that access a table. Can I query the database to identify all the functions the table is in?

Thank you.

 

[Thargy]

ihda,

what's the business requirement here? Your question looks suspiciously like an interview question and/or a homework question.

We tend not to answer such.

Regards

T

 

[ihda]

Our 3rd party software vendor has altered tables. We have written our own reports, etc. to access their data. We will have to rewrite much of our views, functions, and procedures. Rather than going through every object, I would like to identify those that require changing.

 

[LKBrwnDBA]

{ALL|DBA}_DEPENDENCIES


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[Thargy]

fair enough idha. I've been leeched in the past, so I am sometimes suspicious. thanks for your response lkbrwndba - my mistake.

Regards

T