hanson-andrew/new_gist_file

Created March 25, 2013 13:10

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/hanson-andrew/5236989.js"></script>
Save hanson-andrew/5236989 to your computer and use it in GitHub Desktop.

Download ZIP

Pl/SQL snippet to search for text inside compiled procedures/functions. Courtesy of: http://stackoverflow.com/questions/853547/sql-to-search-objects-including-stored-procedures-in-oracle

Raw

new_gist_file

	SELECT owner, name, type, line, text
	FROM dba_source
	WHERE instr(UPPER(text), UPPER(:srch_str)) > 0;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment