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
8856 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 function is used in sql?

934

Is and as keyword in pl sql?

951

what are the authentication modes in sql server? How can it be changed? : Sql dba

1406

What is the use of stored procedures?

1038

How do you create an update query?

955

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

1034

Which are the different types of indexes in sql?

1053

How do I truncate a sql log file?

1061

what is the difference between a local and a global temporary table? : Sql dba

1060

What are pl/sql packages?

1095

What is coalesce in sql?

1046

Are pl sql variables case sensitive?

1039

What is trigger with example?

1083

How do I restart sql?

954

What is a data definition language?

1090