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

I Defined SP1, Sp2 (sp=StoreProcedures)In Package Specification but I Implemented Sp1, sp2, sp3, sp4, sp5 then What type of Error You will find????

3 Answers   Infosys,

How to create a table using constraints... IF i change the PARENT KEY value ,then CHILD KEY table will also to change in the another table... plz reply ur answers @ mak2786@gmail.com Arunkumar

3 Answers  

What is the use of partition by in sql?

0 Answers  

what are numeric data types? : Sql dba

0 Answers  

1. what is the exact use of hint in sql. 2. How we can avoid index scan in sql even though index is there in the table.

1 Answers   Polaris,




Describe the Index, Types of index, At what situation we have used? Which one s better than others?

1 Answers   IBM, TCS,

Which tcp/ip port does sql server run?

0 Answers  

Can we delete column in sql?

0 Answers  

How do I run a query in pl sql developer?

0 Answers  

What program will open a mdb file?

0 Answers  

what is union? : Sql dba

0 Answers  

Is primary key an index?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories