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
- 8197 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 you add a column to a table?
tell us something about heap tables. : Sql dba
What type of database is sql?
Why do we need view in sql?
what is log shipping? : Sql dba
Does asenumerable execute the query?
What are properties of the transaction?
What is attribute indicator in pl sql?
what is the difference between a local and a global temporary table? : Sql dba
How can a pl sql block be executed?
What is write ahead logging in sql server?
Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
What does bitemporal mean?
What are sql constraints?
what are different types of keys in sql?
