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
8760 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 difference between join and union? : Sql dba

1047

Is sqlite good enough for production?

957

how to concatenate two character strings? : Sql dba

1046

What is the use of procedures?

935

What is cursor status?

1140

explain advantages of innodb over myisam. : Sql dba

1091

when is the use of update_statistics command? : Sql dba

987

What do you mean by rowid?

923

What are triggers and its uses?

1009

What do you understand by pl/sql records?

972

What are the advantages of indexing?

940

What are the parameter modes supported by pl/sql?

1037

What are the packages in pl sql?

980

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1168

is mysql query is case sensitive? : Sql dba

1044