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).
- 2 Answers
- 7792 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / raji_4u
CHECK THE VIEW "USER_DEPENDENCIES"
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What does count (*) do in sql?
Is postgresql a nosql database?
What is the usage of nvl function?
Which table is left in join?
What are the types of records?
What does sql stand for?
What is materialized view. What are different methods of refresh?
What is difference between left and right outer join?
What is an implicit commit?
What are the different set operators available in sql?
Can we use commit inside a trigger?
Why cross join is used?
What is varchar data type in sql?
Is primary key clustered index?
Why is sql important?
