Bernandas Savarimuthu
SQL & PL/SQL Colletions
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:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment