Manually Encrypting Data

You can use the DBMS_CRYPTO PL/SQL package to manually encrypt data.

• Security Problems That Encryption Does Not Solve
  While there are many good reasons to encrypt data, there are many reasons not to encrypt data.

• Data Encryption Challenges
  In cases where encryption can provide additional security, there are some associated technical challenges.

• Data Encryption Storage with the DBMS_CRYPTO Package
  The DBMS_CRYPTO package provides several ways to address security issues.

• Asymmetric Key Operations with the DBMS_CRYPTO Package
  The DBMS_CRYPTO package provides four functions that enable you to perform asymmetric key operations for encryption, decryption, signing, and verification.

• Using Ciphertexts Encrypted in OFB Mode in Oracle Database Release 11g
  In Oracle Database Release 11g, ciphertexts configured to use output feedback (OFB) used electronic codebook (ECB) mode instead.

• Examples of Using the Data Encryption API
  Examples of using the data encryption API include using the DBMS_CRYPTO.SQL procedure, encrypting AES 256-bit data, and encrypting BLOB data.

• Data Dictionary Views for Encrypted Data
  Oracle Database provides data dictionary views to find information about encrypted data.