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 ~]$
