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
8725 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 are the benefits of triggers?

1119

What are the various levels of constraints?

1059

what is isam? : Sql dba

950

How delete all data from all tables in sql?

883

What is record data type?

858

how to dump a table to a file with 'mysqldump'? : Sql dba

981

Can you select everything, but 1 or 2 fields, without writer's cramp?

931

how to create a new table by selecting rows from another table in mysql? : Sql dba

1007

What is scope of pl sql developer in future?

948

How do I remove all records from a table?

1023

How to change the order of columns in Oracle SQL Plus ?

993

what are the properties and different types of sub-queries? : Sql dba

966

What are sql commands?

935

Show the cursor attributes of pl/sql.

996

Explain the update statement in sql

916