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).
Answers were Sorted based on User's Feedback
Answer / gaurav
select * from user_source where upper(text)
like '%PO_VENDORS%'
Is This Answer Correct ? | 2 Yes | 1 No |
how to retrieve the top 3 salaries of the table using rownum
Can a procedure in a package be overloaded?
what is sp_pkeys? : Transact sql
What is the difference between a primary key and a clustered index?
What is Temp Table and type of temp table?
IF i write before / after insert / update trigger and i do rollback what will happen?
Begin For j in 4403201000 .. 4403202000 Loop If mod (j, 100) = 0 then Dbms_output.put_line (j); End if; End loop; End; what will be the output of this question
How can we make an if statement within a select statement?
List the differences between plsql - function & procedures
What language is oracle sql developer?
Why self join is used in sql?
What is a sql*loader control file?