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
8862 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 are different functions in sql?

938

How many joins can you have in sql?

930

What is string data type in sql?

1133

What is tuple in sql?

1062

What is using in sql?

1080

What is foreign key and example?

927

which operator is used in query for pattern matching? : Sql dba

1002

discuss about myisam index statistics collection. : Sql dba

944

Can we change the table name in sql?

937

Give the order of sql select?

1133

How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

1121

what is try_catch block in procedure

1733

What is clustered and nonclustered index in sql?

937

What are the built in functions of sql?

1026

What is the clause we need to add in function body to return variable?

1009