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
- 7750 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
What is the difference between a primary key and a unique key?
What is raw datatype in sql?
How do I run sql?
What does the acronym acid stand for in database management?
The select into statement is most often used to create backup copies of tables or for archiving records?
What is the difference between union and union all command?
what are the advantages of using stored procedures? : Sql dba
How to create your own reports in sql developer?
What are the triggers associated with image items?
Where not exists in sql?
What is sql trigger example?
What is the maximum number of rows in sql table?
How do I sort a table in sql?
Is trigger a stored procedure?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
