Showing posts with label oracle translate function. Show all posts
Showing posts with label oracle translate function. Show all posts

Saturday, October 2, 2010

How to use TRANSLATE function?

TO ENCODE TEXT

SELECT TRANSLATE (UPPER('Hello world'),
                  'ABCDEFGHIJKLMNOPQRSTUVWXYZ',
                  '~!@#$%^*()_+=-`/;:><[]{}\|') AS CODE
  FROM DUAL;

TO DECODE TEXT

SELECT TRANSLATE ('*( -(+~\ *`{ ~:$ \`[?',
                  '~!@#$%^*()_+=-`/;:><[]{}\|',
                  'ABCDEFGHIJKLMNOPQRSTUVWXYZ') AS TEXT
  FROM DUAL;