unwrap函数,是把加密的package、procedure、function做解密,适用版本10g,11g,12c
[oracle@db1 ~]$ ./aodu
AT Oracle Database Utility,Release 1.1.0 on Tue Jun 14 00:01:49 2016
Copyright (c) 2014, 2015, Robin.Han. All rights reserved.
http://ohsdba.cn
E-Mail:375349564@qq.com
AODU> unwrap /u01/oracle/product/121/rdbms/admin/prvtstat.plb dbms_stats.sql
AODU> exit
[oracle@db1 ~]$ ls -l dbms_stats.sql
-rw-r--r-- 1 oracle oinstall 1380807 Jun 14 00:02 dbms_stats.sql
CREATE OR REPLACE TYPE BODY wri$_rept_optstats IS OVERRIDING MEMBER FUNCTION GET_REPORT(REPORT_REFERENCE IN VARCHAR2) RETURN XMLTYPE IS COMPONENT_NAME VARCHAR2(30); REPORT_NAME VARCHAR2(30); PARAMS DBMS_REPORT.REF_STRING_IDSPEC; SINCE TIMESTAMP WITH TIME ZONE; UNTIL TIMESTAMP WITH TIME ZONE; AUTO_ONLY BOOLEAN := FALSE; DETAIL_LEVEL VARCHAR2(10); LATESTN NUMBER := NULL; CONTAINER_IDS_TXT VARCHAR2(32767); CONID_TAB DBMS_UTILITY.NUMBER_ARRAY; START_IX NUMBER; CONID_TXT VARCHAR2(100);
CONID NUMBER := NULL; CONID_IX NUMBER := 1; [oracle@db1 ~]$