OraFAQ Forum: Security » Date encryption/decryption on Oracle 8.1.5

Home » RDBMS Server » Security » Date encryption/decryption on Oracle 8.1.5

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Date encryption/decryption on Oracle 8.1.5 [message #42883]

Mon, 19 May 2003 03:33

Anindita Mukhopadhyay
Messages: 2
Registered: May 2003

Junior Member

Pl guide me how to encrypt a password and store in the database and if req how to decrypt that in Oracle 8.1.5?

Report message to a moderator

Re: Date encryption/decryption on Oracle 8.1.5 [message #42914 is a reply to message #42883]

Tue, 20 May 2003 22:31

amit zhankar
Messages: 31
Registered: March 2003

Member

This is the simple way of encode and decode the word

SELECT TRANSLATE(
'HELLO WORLD', -- Message to encode
'ABCDEFGHIJKLMNOPQRSTUVWXYZ ',
'1234567890!@#$%^&*()-=_+;,.') ENCODED_MESSAGE
FROM DUAL
/

SELECT TRANSLATE(
'85@@%._%*@4', -- Message to decode
'1234567890!@#$%^&*()-=_+;,.',
'ABCDEFGHIJKLMNOPQRSTUVWXYZ ') DECODED_MESSAGE
FROM DUAL
/

Report message to a moderator

Previous Topic:	How to create SQL account on WinXP
Next Topic:	ERROR...WHEN I TYPE PASSWORD

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 24 07:35:20 CST 2025