Oracle gravel of the day: grepping your PL/SQL

jdavidb on 2007-04-26T19:34:30

This is one of those days:

SELECT owner, name, type
FROM all_source
WHERE owner LIKE '....'
  AND UPPER(text) LIKE '....';