Skip to content

Function

find functions with specific string

SELECT * 
FROM ALL_OBJECTS 
WHERE OBJECT_TYPE IN ('FUNCTION','PROCEDURE','PACKAGE') and lower(object_name) like '%data%';

show function definition

select text 
from all_source 
where type = 'FUNCTION' and name = 'my_func_name'
order by line;