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
8749 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 recursive stored procedure? : Sql dba

938

Does varchar need length?

942

Why is the cursor important?

987

how to calculate expressions with sql statements? : Sql dba

995

what is a composite primary key ? : Sql dba

1005

Which software is used for pl sql programming?

936

What are schema-level triggers?

1053

What is rollback?

1048

Is truncate ddl or dml?

947

What does dml mean?

935

What do you understand by case manipulation functions?

958

Is big data nosql?

894

Is sql between inclusive?

1073

what is the difference between a having clause and a where clause? : Sql dba

1017

Why primary key is required?

943