调用相应的API对BLOB数据 相应的加密和解密
--加密 function encrypt_aes256 (p_blob in blob, p_key in varchar2) return blob as l_key_raw raw(32); l_returnvalue blob; begin /* Purpose: encrypt blob Remarks: p_key should be 32 characters (256 bits / 8 = 32 bytes) Who Date Description ------ ---------- ------------------------------------- MBR 20.01.2011 Created */ --获得 raw类型的key l_key_raw := utl_raw.cast_to_raw (p_key); dbms_lob.createtemporary (l_returnvalue, false); dbms_crypto.encrypt (l_returnvalue, p_blob, g_encryption_type_aes, l_key_raw); return l_returnvalue; end encrypt_aes256; --解密 function decrypt_aes256 (p_blob in blob, p_key in varchar2) return blob as l_key_raw raw(32); l_returnvalue blob; begin /* Purpose: decrypt blob Remarks: p_key should be 32 characters (256 bits / 8 = 32 bytes) Who Date Description ------ ---------- ------------------------------------- MBR 20.01.2011 Created */ l_key_raw := utl_raw.cast_to_raw (p_key); dbms_lob.createtemporary (l_returnvalue, false); dbms_crypto.decrypt (l_returnvalue, p_blob, g_encryption_type_aes, l_key_raw); return l_returnvalue; end decrypt_aes256; --该片段来自于http://outofmemory.cn
收藏
0人收藏
- 2014-10-26 09:52:21使用MD5编码实现数据库用户密码字段的加密 by Sycro
- 2014-11-10 15:57:52Sql Server常用Sql精华搜集整理 by Ev4n
- 2014-05-05 10:04:55Sql Server常用Sql精华搜集整理 by 二糊
- 2014-07-11 18:17:02Sql Server计算代码执行时间 by 董一碗
- 2014-08-30 11:03:05MySQL查看用户权限 by 董一碗
- 2017-08-04 12:04:30SQL Server枚举数据库中的空表 by 吴红军
- 2017-08-11 10:32:28谁来帮帮我啊,oracle查询好慢呢 by Merrill
- 2017-08-17 16:45:21查询某列字段是否存在空回车/空换行符 by 羊半仙
- 2017-08-25 10:33:49列出指定表的所有字段 by 吴红军
- 2017-09-09 10:19:55删除存储过程 by Merrill
- 2017-12-11 17:37:06表变量,代替临时表 by xuleaper
相关聚客文章