Search Oracle procedure by its inner text content
In Oracle one can search for name and the content of any stored procedure where "YOUR_SEARCH_KEY" is is referenced within the stored procedure.
The following query will fetch the details those having the "YOUR_SEARCH_KEY"
SELECT * FROM ALL_SOURCE WHERE LOWER(text) LIKE LOWER('%YOUR_SEARCH_KEY%')
Where,
ALL_SOURCE - Describes the text source of the stored objects accessible to the ...
Read more...
Posts
