《oracle wrap 和 unwrap》由会员分享，可在线阅读，更多相关《oracle wrap 和 unwrap（25页珍藏版）》请在金锄头文库上搜索。
1、Oracle wrap 和 unwrap（ 加密与解密） 说明一. Wrap 说明官网的说明如下：APL/SQL Source Text Wrappinghttp:/ can wrap the PL/SQL source text for any of thesestored PL/SQL units, therebypreventing anyone from displaying or editing that text: （1）Package specification （2）Package body （3）Type specification （4）Type body （5）Funct
2、ion （6）Procedure A file containing wrapped PL/SQL source text is called awrapped file. Awrapped file can be moved, backed up, or processed by SQL*Plus or the Importand Export utilities. To produce a wrapped file, use either the PL/SQL Wrapper utility or aDBMS_DDLsubprogram.The PL/SQL Wrapper utility
3、 wraps the source text of every wrappable PL/SQL unitcreated by a specified SQL file. TheDBMS_DDLsubprograms wrap thesource text of single dynamically generated wrappable PL/SQL units. Both the PL/SQL Wrapper utility andDBMS_DDLsubprograms detecttokenization errors (for example, runaway strings), bu
4、t not syntax or semanticerrors (for example, nonexistent tables or views). Wrapped files are upward-compatible between Oracle Database releases. For example, youcan load files produced by the V8.1.5 PL/SQL Wrapper utility into a V8.1.6 OracleDatabase.itpub上有篇文章提到了wrap 加密的原理： From:http:/ Oracle加密的原理就
5、是先对源码进行lz压缩lzstr，然后对压缩数据进行SHA-1运算得到40位的加密串shstr，然后将加密串与压缩串拼接得到shstr+lzstr，然后对拼接后的字符串进行Oracle双字符转换（转换表）。最后将转换后的字符串进行base64编码，最终得到wrap的加密串。 The default file extension forinput_fileissql. The default nameofoutput_fileisinput_file.plb. Therefore, these commands are equivalent: wrapiname=/mydir/myfile wr
6、apiname=/mydir/myfile.sql oname=/mydir/myfile.plbThisexample specifies a different file extension forinput_fileand adifferent name foroutput_file: wrapiname=/mydir/myfile.src oname=/yourdir/yourfile.outwrap 的使用步骤如下：（1）将我们要加密的sql 语句保存到一个sql文本里。（2）用wrap 进行处理，指定输入的sql，即我们第一步的问题，然后指定输出的路径和文件名，默认扩展名是plb。
7、（3）执行我们第二部进过wrap 处理的sql，即plb文件，创建我们的对象.示例1：wrap funcation-函数CREATE OR REPLACE FUNCTION F_DAVE ( n int) RETURN stringISBEGIN IF n = 1 THEN RETURN Dave is DBA!; ELSIF n = 2 THEN RETURN Dave come from AnQing!; ELSE RETURN Dave come from HuaiNing!; END IF;END;/SYSdave2(db2) select F_DAVE(4) fromdual;F_D
8、AVE(4)-Dave come from HuaiNing!BTW： 今天群里有人问我的blog的例子里为啥有安庆，因为我是安庆怀宁人。oracledb2 $ pwd/home/oracleoracledb2 $cat dave.sqlCREATE OR REPLACE FUNCTION F_DAVE ( n int) RETURNstringISBEGIN IF n = 1 THEN RETURN Dave is DBA!; ELSIF n = 2 THEN RETURN Dave come from AnQing!; ELSE RETURN Dave come from HuaiNing
9、!; END IF;END;/oracledb2 $wrap iname=dave.sqlPL/SQL Wrapper: Release 10.2.0.1.0-Production on Thu Aug 18 22:59:14 2011Copyright (c) 1993, 2004, Oracle. All rights reserved.Processing dave.sql to dave.plboracledb2 $ lsbifile.bbddave.plb dave.sql Desktoplog.bbdoracledb2 $cat dave.plbCREATE OR REPLACE
10、FUNCTION F_DAVE wrappeda0000001abcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcd810d e7S9NWrpt8q6tkKEMxCcfYJz2aLF4wgxDQLZ4VfC9AkE6OnV4ydypXGhveHcDg8UXy98WIg6xRcrtc/BRdQJjutbna/9+g0LlaSx87/znV+y926S1AeC0IRi/tjPJTyvJereDdk8mftMo8QMjVfw0xXn0zVagAawwNVhSAiy/JPTMKkrBkC5ruMwQSTe6JQNq7Q2QtJV0hgQ
11、ou0rYuet4/gJ5BwAj75ph6EA=/SYSdave2(db2) dave.plb-再次调用函数，正常使用：SYSdave2(db2) select F_DAVE(4) fromdual;F_DAVE(4)-Dave come from HuaiNing!-查看函数源码，已经加过密了：SYSdave2(db2) select text fromdba_source where name=F_DAVE;TEXT-FUNCTION F_DAVE wrappeda0000001abcdabcdabcdabcdabcdabcdabcdabcdTEXT-abcdabcdabcdabcdab
12、cdabcdabcd810d e7S9NWrpt8q6tkKEMxCcfYJz2aLF4wgxDQLZ4VfC9AkE6OnV4ydypXGhveHcDg8UXy98WIg6xRcrtc/BRdQJjutbna/9+g0LlaSx87/znV+y926S1AeC0IRi/tjPJTyvJereDdk8mftMo8QMjVTEXT-fw0xXn0zVagAawwNVhSAiy/JPTMKkrBkC5ruMwQSTe6JQNq7Q2QtJV0hgQou0rYuet4/gJ5BwAj75ph6EA=示例2：SYS.DBMS_DDL 函数 thedbms_ddlpackage provideswrapfunctionsandcreate_wrappedprocedures, each of whichwraps the pl/sql source text of a single dynamically generate
