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
- 7759 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
Can we use the cursor's to create the collection in PL/SQL?
How do you use a while loop in pl sql?
Is sql pronounced sequel or sql?
What is the use of double ampersand (&&) in sql queries? Give an example
How many types of indexes are there in sql?
What is not equal in sql?
What is sp_helptext?
Show the cursor attributes of pl/sql.
Can we rollback after truncate?
What is the use of %rowtype?
when MSQL8.0 is in market
how mysql optimizes distinct? : Sql dba
What types of commands can be executed in sql*plus?
Enlist the characteristics of pl/sql?
Does group by remove duplicates?
