Mega Code Archive

 

Categories / Oracle PLSQL / Char Functions

 

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>