Thursday, April 11, 2013

Orace SQL: Search through all PLSQL package bodies for a string


SELECT * FROM user_source WHERE upper(text) like '%Your Search here%'  AND type = 'PACKAGE BODY';

OR


SELECT * FROM all_source WHERE upper(text) like '%Your Search here%';


No comments:

Post a Comment