Re: Encryption/Decrypting Oracle Data

dbaplusplus_at_hotmail.com wrote:

>
> I am interested in encrypting cLOB and BLOB. Are they supported in 10G
> R2 release.
>

No, they're not.

I would suggest to take a look at http://otn.oracle.com. I suspect from your post, using obfuscation and crypto, that you want data to be encrypted, and only unencrypted when the user is allowed to see it - it should remain encrypted for all other.
Transparent Data Encryption is *transparent* - data is visible as if unencrypted within the database; it's stored (to disk) in an encrypted way.
You might also want to read this:
http://vanbortel.blogspot.com/2005/07/oracle-10g-transparant-data-encryption.html

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...