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