How many database objects (trigger, packages, sequence etc) uses a particula

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

2 Answers
8993 Views
IBM, I also Faced
E-Mail Answers

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

Explain how can you save or place your msg in a table?

0 Answers

Can a key be both primary and foreign?

0 Answers

What SQL keyword must immediately follow the UNION ALL statement? 1. SELECT 2. INTO 3. ORDER 4. WHERE 5. JOIN

4 Answers

What is a ddl command?

0 Answers

What do you mean by field in sql?

0 Answers

Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?

0 Answers

1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...

0 Answers Satyam,

i have a table t1 a math 20 b phy 30 cchemisty 10 a math 40 b phy 23 c che 21 a math15 bphy 33 c che 56 write a quire to find out the max markr of each subject

8 Answers

What is full join in sql?

0 Answers

What is the difference between local variables and global variables?

0 Answers

What is sql trigger example?

0 Answers

How will you select unique values from a list of records?

7 Answers Cap Gemini,

For more SQL PLSQL Interview Questions Click Here