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
- 8198 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / gaurav
select * from user_source where upper(text)
like '%PO_VENDORS%'
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
explain access control lists. : Sql dba
how to run 'mysql' commands from a batch file? : Sql dba
What is difference between sql and oracle?
how to enter binary numbers in sql statements? : Sql dba
what is a database transaction? : Sql dba
What is a field in a database?
What is rollback?
What is pls_integer in pl sql?
Explain the purpose of %type and %rowtype data types?
what is row? : Sql dba
how to select first 5 records from a table? : Sql dba
Can we call stored procedure in function?
What company owns postgresql?
What is the benefit of foreign key?
What are the usages of sql?
