<syntaxhighlight lang="sql"> SELECT *
FROM DBA_SOURCE WHERE TYPE='PROCEDURE' AND TEXT LIKE '%PROD_ID%';
</syntaxhighlight>