30 May 2008

Oracle Apps: How to find Database Package

Use following SQL to find Stored Procedure/Packages used by an Table/View/Message/SP

SELECT * FROM DBA_SOURCE WHERE TEXT LIKE '%Object Name%'

So simple naaa

No comments: