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
- 7752 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 are wild cards used in database for pattern matching ? : Sql dba
How to pipe multiline string to isql?
How do I run a sql script?
How many postgresql users are there, worldwide?
How many commands are there in sql?
Whis is not false in primary key?
What is the difference between a subquery and a join?
What is query optimization in sql?
What is a primary key sql?
How do I pipe the output of one isql to another?
Explain some predefined exceptions.
what is the use of set statement in tsql? : Transact sql
Explain 3 basic parts of a trigger.
How do I view a view in sql?
How do I run a sql query?
