Want to post your scripts here in this blog ? Email it to snojha@gmail.com. You will be rewarded for your scripts if selected by our experts.

Wednesday, January 13, 2010

determine if pl/sql code is wrapped or not

select owner||'.'||name from dba_source
where
line=1
and
owner not in ('SYS', 'CTXSYS', 'MDSYS', 'ODM', 'OE', 'OLAPSYS',
'ORDPLUGINS', 'ORDSYS', 'OUTLN', 'PM', 'QS_ADM',
'RMAN', 'SYSTEM', 'WKSYS','WMSYS','XDB')
and
owner not like 'OEM%'
and
text not like '%wrapped%'
and
type in ('PACKAGE BODY','FUNCTION','PROCEDURE');

No comments: