CHECK THE VIEW "USER_DEPENDENCIES"

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 / raji_4u

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

Answer Posted / raji_4u

CHECK THE VIEW "USER_DEPENDENCIES"

Is This Answer Correct ?

5 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Why do we need cursors in pl sql?

1151

What are the different schemas objects that can be created using pl/sql?

1082

What is the difference between join and natural join?

980

how can you create an empty table from an existing table? : Sql dba

1195

What is trigger types of trigger?

1140

What is t-sql? : Transact sql

1039

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

1062

What is a schema? How is it useful in sql servers?

1174

Which data type is a composite type?

1035

How to connect a sql*plus session to an oracle server?

1173

What is percent sign in sql?

1324

What is gpt format?

991

Explain foreign key in sql?

1079

Is join same as left join?

1080

What is a constraint?

1082