rss
twitter

Monday, September 16, 2013

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 current user. 
User can also use any of the following according to their need,
  • DBA_SOURCE - Describes the text source of all stored objects in the database.
  • USER_SOURCE - Describes the text source of the stored objects owned by the current user. This view does not display the OWNER column.

Bookmark and Share

0 comments:

Post a Comment

  © Blogger templates by Ourblogtemplates.com updated with zenplate.com tips

Back to TOP