Home » RDBMS Server » Security » Date encryption/decryption on Oracle 8.1.5
Date encryption/decryption on Oracle 8.1.5 [message #42883] Mon, 19 May 2003 03:33 Go to next message
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?
Re: Date encryption/decryption on Oracle 8.1.5 [message #42914 is a reply to message #42883] Tue, 20 May 2003 22:31 Go to previous message
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
/
Previous Topic: How to create SQL account on WinXP
Next Topic: ERROR...WHEN I TYPE PASSWORD
Goto Forum:
  


Current Time: Sun Sep 26 22:44:26 CDT 2021