To search a text inside a oracle database function or package, We can use this query
select * from USER_SOURCE where upper(TEXT) like '%search text%'
USER_SOURCE describes the text source of the stored objects owned by the current user. Its columns (except for OWNER) are the same as those in "ALL_SOURCE".
- http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/statviews_4436.htm
This entry was posted
on Mar 31, 2009
at Tuesday, March 31, 2009
and is filed under
Oracle
. You can follow any responses to this entry through the
comments feed
.