select * from user_source where upper(text) like '%PO

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 / gaurav

2 Answers
8992 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / gaurav

select * from user_source where upper(text)
like '%PO_VENDORS%'

Is This Answer Correct ?

2 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the maximum number of triggers, you can apply on a single table?

1046

What is meant by temporal data?

1000

How to pipe multiline string to isql?

1049

How do I upgrade sql?

1048

How do I restart sql?

1024

Why is a primary key important?

1104

How to use sql*plus built-in timers?

1260

What is sql architecture?

1102

what are the drivers in mysql? : Sql dba

1059

What is data definition language?

1135

Why use stored procedures?

1140

What is a clob in sql?

1063

What are its different types of dbms?

1052

What is orm in sql?

1099

What does the argument [or replace] do?

1125