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

Which is better join or subquery?

1137

what is query cache in mysql? : Sql dba

1037

How do I run a pl sql procedure in sql developer?

970

What are character functions?

1088

Who developed sql?

1049

How can you fetch first 5 characters of the string?

1018

How do I run a sql query in pgadmin 4?

962

How delete all data from table in sql?

1019

Explain raise_application_error.

1099

What is on delete set null?

1089

How do you use a while loop in pl sql?

1014

What is difference between stored procedures and application procedures?

1013

What is the difference between a primary key and a clustered index?

993

What is a recursive stored procedure?

1185

How is use pl and sql?

1064