Skip to Main Content

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!

Decrypting field using dbms_obfuscation_toolkit.DESEncrypt

Johnny98Oct 28 2014 — edited Oct 29 2014

Hello,

I encrypted a field using the following update statement:

UPDATE table1

  SET dob= dbms_obfuscation_toolkit.md5( input_string => ''31-MAY-2001' )

WHERE table1id= 123;

Now my dob field is encrypted.  How can I decrypt it to see the date of '31-MAY-2001' again?  I was trying to get this to work, but not sure I'm on the right track:

select dob,dbms_obfuscation_toolkit.DESEncrypt(

                   input_string => dob,

                   key_string => 'scottsco',

                   encrypted_string => '˜}Ê<Mæ×^u.ò†Œ­ß]' )

from table1 where table1id = 123;

Thanks very much in advance!

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 26 2014
Added on Oct 28 2014
10 comments
811 views