Skip to content

Instantly share code, notes, and snippets.

@joseporiol

joseporiol/search_on_packages.sql

Created January 21, 2014 10:23
Show Gist options
  • Save joseporiol/8537608 to your computer and use it in GitHub Desktop.
Save joseporiol/8537608 to your computer and use it in GitHub Desktop.
Download ZIP
Find string in package source code Below query will search for string ‘FOO_SOMETHING’ in all package source. This query comes handy when you want to find a particular procedure or function call from all the source code.
Raw
search_on_packages.sql
--search a string foo_something in package source code
SELECT *
FROM dba_source
WHERE UPPER (text) LIKE '%FOO_SOMETHING%'
AND owner = 'USER_NAME';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment