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



How many database objects (trigger, packages, sequence etc) uses a particular field in a given t..

Answer / raji_4u

CHECK THE VIEW "USER_DEPENDENCIES"

Is This Answer Correct ?    5 Yes 1 No

How many database objects (trigger, packages, sequence etc) uses a particular field in a given t..

Answer / gaurav

select * from user_source where upper(text)
like '%PO_VENDORS%'

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More SQL PLSQL Interview Questions

how to retrieve the top 3 salaries of the table using rownum

31 Answers   Oracle,


Can a procedure in a package be overloaded?

0 Answers   EXL,


what is sp_pkeys? : Transact sql

0 Answers  


What is the difference between a primary key and a clustered index?

0 Answers  


What is Temp Table and type of temp table?

1 Answers   HP, SLK,


IF i write before / after insert / update trigger and i do rollback what will happen?

5 Answers   KPIT,


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

7 Answers   TCS,


How can we make an if statement within a select statement?

0 Answers  


List the differences between plsql - function & procedures

2 Answers   TCS, Verizon,


What language is oracle sql developer?

0 Answers  


Why self join is used in sql?

0 Answers  


What is a sql*loader control file?

0 Answers  


Categories