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
8880 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

Can we delete column in sql?

1099

What are different types of indexes?

1010

Which are the different case manipulation functions in sql?

1023

Explain what is sql?

1119

what are the nonstandard string types? : Sql dba

1138

Is sql sequential or random?

1037

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

1005

What is a parameter query?

1084

Why are cursors used?

1122

what is 'mysqlimport'? : Sql dba

1054

Why do we need sharding?

990

what is the difference between myisam static and myisam dynamic? : Sql dba

1065

What is sql profiler in oracle?

1094

How do we accept inputs from user during runtime?

1064

Sql technical questions

1283