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

Explain the order of sql statement execution?

976

Does sql profiler affect performance?

939

What are the set operators in sql?

1027

What is pivot table in sql?

1017

Is sql a backend language?

1038

Explain the insert into statements in sql?

935

What is online transaction processing (oltp)?

961

What do you mean by stored procedures?

951

List and explain the different types of join clauses supported in ansi-standard sql?

1300

Can a foreign key be null?

1029

How to Execute a Package in PL/SQL.?

1108

What are the different ddl commands in sql?

1065

what is an alias command? : Sql dba

1007

Enlist some predefined exceptions?

994

what are sequences

1618