Encryption on Oracle

[zephan]

Hi All,
I want to store encrypted data on an Oracle Database. At first, the data is stored in a PGP encrypted file, of course I own the private key.
The clear text is a list of values, each value in a line.
What I'm thinking about is writing two functions encrypt(value) and decrypt(encrypted_value).
How can I do this.
Thank you in advance for your help.

 

[zephan]

I would like to precise. Actually the encrypted file is not an issue, so let's assume the file is clear.

PGP is not an issue neither, I need any technology to encrypt and decript a single value from the file.

 

[LKBrwnDBA]

You could use the DBMS_CRYPTO or the DBMS_OBFUSCATION_TOOLKIT packages.


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[Thargy]

I believe that in 10g Oracle provides transparent encryption of tablespaces, so you might want to consider using 10g, and just trun on the built-in encryption facility. No coding effort required on your part

Regards

T