EXPERT RESPONSE
You'll have to use the same mechanism to encrypt your data. You won't
be able to just insert the raw data into the table and then have it be
encrypted after the fact. I'm assuming that you are using some sort of
encryption routine in your Java application.
If you are using Oracle's DBMS_OBFUSCATION_TOOLKIT package to encrypt
your sensitive data, then you can insert the raw data and then simply
call the DBMS_OBFUSCATION_TOOLKIT package to perform the encryption. I
have a white paper titled, "Encrypting data in the database," on my Web
site (http://www.peasland.net), which discusses how to do this. But you'll need to know the encryption keys otherwise you won't be able to unencrypt either.
|
