The Incident Archive

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%';

Goto tools / Prefrences in the top menu in Jdeveloper Select Database/ Worksheets Check AutoCommit in SQL Worksheet off / on as you wish