Wednesday, June 9, 2010

Translate Function

SELECT TRANSLATE('bernandas', 'abcdefghijklmnopqrstuvxyz', '0123456789qwertyuiop[kjhbv')
FROM DUAL;

Output
------

14ir0r30o


SELECT TRANSLATE('14ir0r30o', '0123456789qwertyuiop[kjhbv', 'abcdefghijklmnopqrstuvxyz')
FROM DUAL;

Output
------

bernandas

No comments: