USE : user_source table
select * from user_source where type = ‘PROCEDURE’ and lower(text) like lower(‘%text%’);
select * from user_source where type = ‘PROCEDURE’ and lower(text) like lower(‘%text%’);