Protected by Copyscape Web Copyright Protection Software

Search This Blog

Saturday, June 8, 2013

How to know where my Package is stored in oracle?

SELECT  *
FROM    ALL_SOURCE
WHERE   TYPE IN ('PACKAGE', 'PACKAGE BODY')
AND     TEXT LIKE '%NNNN%'