Levels of Encryption

You can use SET ENCRYPTION PASSWORD with encryption and decryption functions to support these granularities of encryption in the database.

• Column-Level Encryption: All values in a given column of a database table are encrypted using the same password, the same encryption algorithm, and the same encryption mode. (In this case, you can save disk space by storing the hint outside the encrypted column, rather than repeating it in every row.)
• Cell-Level Encryption: Values of a given column in different rows of the same database table are encrypted using different passwords, or different encryption algorithms, or different encryption modes. This technique is sometimes necessary to protect personal data. (Row-column level encryption and set-column level encryption are both synonyms for cell-level encryption.)