Find the all stored procedures where a table is being used by query in ORACLE

	SELECT distinct name FROM ALL_SOURCE WHERE TYPE = 'PROCEDURE'
	AND Name like '%Procedure_Name'
	AND Text like '%Table_Name%'

view raw gistfile1.txt hosted with ❤ by GitHub