1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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).

Question Posted / nm

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

What is the difference among union, minus and intersect?

0 Answers  

explain the advantages and disadvantages of stored procedure? : Sql dba

0 Answers  

What is normalization? dec 2009

3 Answers   Cognizant,

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

0 Answers  

What is the use of a view in sql?

0 Answers  




what are the differences between binary and varbinary? : Sql dba

0 Answers  

what is the difference between granting and creating a view?

2 Answers  

select * from emp where sal in(select max(sal) from emp) here there is any limit for in operator how many values accpect ?

2 Answers  

What is sql in oracle?

0 Answers  

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

0 Answers  

What is the difference between left join and right join?

0 Answers  

What is normalization and types of normalization?

22 Answers   Etisbew, F-TEC, Microsoft, TechProcess,

For more SQL PLSQL Interview Questions Click Here
Categories