SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Date field encryption using Dbms_Obfuscation_Toolkit.DESENCRYPT

924279Mar 15 2012 — edited Mar 15 2012

Hi,

I need to encrypt the date field in the table using Dbms_Obfuscation_Toolkit.DESENCRYPT .
This is an table is an existing table and is accessed by many interfaces, so we cannot change the column type of this date field.

Is there a possibility of encrypting the date field and store it in the same column (DATE type).
And access this using Dbms_Obfuscation_Toolkit.DESDECRYPT.

We are using Oracle 11.2.0.2.0.

Thanks in advance.

Agathya

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 12 2012

Added on Mar 15 2012

1 comment

254 views