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

What is the need of a partition key?

985

Does oracle roll back the transaction on an error?

1013

what is difference between delete and truncate commands? : Sql dba

1129

What is foreign key and example?

935

how would you get the current date in mysql? : Sql dba

967

What is execution plan in sql?

1041

What does cursor do in sql?

1018

What is natural join in sql?

987

how to present a past time in hours, minutes and seconds? : Sql dba

1011

What is sql injection owasp?

1060

What is sql not null constraint?

1035

How to use boolean type in select statement?

1073

Is sql a oracle?

978

Explain select statements in sql?

1056

Why is stored procedure faster than query?

960