Oracle DB Object Search 1

[speial]

I am reverse engineering an application process. The application is on Oracle 10G DB. I want to search all DB Objects for a particular text string. I am using SQL Navigator as the development tool.

Example > I am looking for the string: "insert into his_call". There are over 2,000 db objects. I could open each object and perform a text search but, that would take a very long time.

Does anyone have a solution to perform this search ?

 

[Dagon]

Do you mean you want to search for that string in all text columns of all tables ? Or do you mean search all code objects like triggers, stored packages etc ? If the latter, you could do:

select * from sys.dba_source
where lower(text) like '%insert into his_call%'
/



Retired (not by choice) Oracle contractor.

 

[speial]

Yes. This is what I was looking for. Let me give it a try. Many thanks.