3

I trying to find out a word/string named 'audapro_ind' in oracle database in toad. This word can be present anywhere in column of table, function, procedure etc. in oracle database

I tried few queries like

select name , line,text from dba_source where upper(text) like 
upper ('audapro_ind') escape '\'

also

select DISTINCT(name) from user_source where type = 'PROCEDURE'
 AND text_like 'audapro_ind'

But could not able to find the solution

Sudip7
  • 131
  • 1
  • 1
  • 4

1 Answers1

4

You can use this:

select name , line,text from dba_source where regexp_like(text,'audapro_ind','i');

'i' specifies case-insensitive matching.

Dieter DHoker
  • 344
  • 1
  • 8