Mega Code Archive

 

Categories / Oracle PLSQL / Char Functions

 

From_template argument can contain more characters than to_template

SQL> SQL> SELECT   2       TRANSLATE('4428-2174-5093-1501'   3                ,'0123456789-'   4                ,'XXXXXXXXXX*')  hide_num   5  FROM dual; HIDE_NUM ------------------- XXXX*XXXX*XXXX*XXXX