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
- 7764 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
How do I find duplicates in the same column?
How to get unique records from a table?
How to rename a table?
How to order siblings in oracle hierarchy queries?
How many joins can you have in sql?
how would you get the current date in mysql? : Sql dba
What is sql integrity?
Which is better join or inner query?
What are the different types of tables in sql?
Is not equal in sql?
Which operator is used in query for pattern matching?
how to use case expression? : Sql dba
How do you use join?
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
What are the limitations of sql express?
