Live ORACLE

rem -----------------------------------------------------------------------
rem Filename:   encode.sql
rem Purpose:    Demonstrate simple encoding and decoding of secret messages 
rem             This method can be extended to create simple password
rem             encryption
rem Date:       15-Feb-2001
rem Author:     Frank Naude, Oracle FAQ
rem -----------------------------------------------------------------------

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
/

Encoding and Decoding of Secret Messages