How many database objects (trigger, packages, sequence etc) uses a particula

How many database objects (trigger, packages, sequence etc)
uses a
particular field in a given table.
For ex: I want to know how many database object uses the
ATTRIBUTE1 in
the PO_VENDORS table.

What query will give me the result showing the database
object
name(package, trigger etc),
field_name used (in this case ATTRIBUTE1) and table_name
(in this case
PO_VENDORS).

Question Posted / nm

2 Answers
8191 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How many database objects (trigger, packages, sequence etc) uses a particular field in a given t..

Answer / raji_4u

CHECK THE VIEW "USER_DEPENDENCIES"

Is This Answer Correct ?

5 Yes

1 No

How many database objects (trigger, packages, sequence etc) uses a particular field in a given t..

Answer / gaurav

select * from user_source where upper(text)
like '%PO_VENDORS%'

Is This Answer Correct ?

2 Yes

1 No

Post New Answer