This content has been marked as final. Show 2 replies
r using any third party tool...?
I am using sql developer and F8 to see the sql query executed. we can filter it by searching the word BEGIN.
is there any othere way..?
experts pls answer..?
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');