This content has been marked as final. Show 2 replies
A select statement can include a pl/sql function call so you cannot exclude selects and search only the begin keyword.
You could join with DBA_OBJECTS, but is not very precise:
select * from v$sql, dba_objects where upper(sql_text) like '%'||object_name||'%' and object_type in ('PACKAGE','PROCEDURE','FUNCTION');