oracle加密函数

http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_crypto.htm
oracle自带文档写的比较清楚
24

DBMS_CRYPTO
DBMS_CRYPTO
provides an interface to encrypt and
decrypt stored data, and can be used in conjunction with PL/SQL
programs running network communications. It provides support for
several industry-standard encryption and hashing algorithms, including
the Advanced Encryption Standard (AES) encryption algorithm. AES has
been approved by the National Institute of Standards and Technology
(NIST) to replace the Data Encryption Standard (DES).
See Also:
Oracle Database Security Guide
for further information about using this package and about encrypting data in general.
This chapter contains the following topics:
Using the DBMS_CRYPTO Subprograms
Overview
Security Model
Types
Algorithms
Restrictions
Exceptions
Operational Notes
Summary of DBMS_CRYPTO Subprograms
Using the DBMS_CRYPTO Subprograms
Overview
Security Model
Types
Algorithms
Restrictions
Exceptions
Operational Notes
Overview
DBMS_CRYPTO
contains basic cryptographic functions and
procedures. To use this package correctly and securely, a general level
of security expertise is assumed.
The DBMS_CRYPTO
package enables encryption and decryption for common Oracle datatypes, including RAW
and large objects (LOB
s), such as images and sound. Specifically, it supports BLOB
s and CLOB
s. In addition, it provides Globalization Support for encrypting data across different database character sets.
The following cryptographic algorithms are supported:
Data Encryption Standard (DES), Triple DES (3DES, 2-key and 3-key)
Advanced Encryption Standard (AES)
MD5, MD4, and SHA-1 cryptographic hashes
MD5 and SHA-1 Message Authentication Code (MAC)
Block cipher modifiers are also provided with DBMS_CRYPTO
.
You can choose from several padding options, including PKCS (Public Key
Cryptographic Standard) #5, and from four block cipher chaining modes,
including Ciph