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"
Where,
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.
- 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.
0 comments:
Post a Comment