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 /