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

Is trigger a stored procedure?

938

What is trigger in sql? Explain

1000

How is a PL/SQL code compiled?

1242

How do I count rows in sql query?

1003

Who developed sql?

1054

What is a parameter query?

1092

What are the popular database management systems in the it industry?

1004

What is the difference between join and natural join?

937

What is %type in sql?

971

how can we submit a form without a submit button? : Sql dba

997

How does cross join work in sql?

1027

How do I view an execution plan in sql?

994

how to convert character strings to dates? : Sql dba

1070

how to create a new table in mysql? : Sql dba

997

What is the file extension for sql database?

1012