Skip to Main Content

Oracle Database Discussions

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!

how to decrypt this thing?

4e8e22b5-5ec3-404d-8add-ba49836adde4Jun 26 2015 — edited Jun 26 2015

How can i decrypt using cc, md4,md5 and sh1 ?

please help me?

DECLARE

l_credit_card_no VARCHAR2(19) := '1234-5678-9012-3456';

l_ccn_raw RAW(128) := utl_raw.cast_to_raw(l_credit_card_no);

l_encrypted_raw RAW(2048);

BEGIN

dbms_output.put_line('CC: ' || l_ccn_raw);

l_encrypted_raw := dbms_crypto.hash(l_ccn_raw, 1);

dbms_output.put_line('MD4: ' || l_encrypted_raw);

l_encrypted_raw := dbms_crypto.hash(l_ccn_raw, 2);

dbms_output.put_line('MD5: ' || l_encrypted_raw);

l_encrypted_raw := dbms_crypto.hash(l_ccn_raw, 3);

dbms_output.put_line('SH1: ' || l_encrypted_raw);

end;

CC: 313233342D353637382D393031322D33343536

MD4: 434C7C30E899FA75021552F18BE926DA

MD5: 5A51B1ACC2F034E8CDD662F4C91EE7F3

SH1: 44AA647728E6FA5A0B7B098C1B50492B052BB91E

i need the dbms to be convert back to it's normal form which is '1234-5678-9012-3456'

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 24 2015
Added on Jun 26 2015
4 comments
806 views