TRANSLATE('555-143-3344', '1234567890','XXXXXXXXXX') phone
SQL> SQL> SQL> SELECT TRANSLATE('555-143-3344', '1234567890','XXXXXXXXXX') phone 2 FROM dual; PHONE ------------ XXX-XXX-XXXX Page 1 SQL>