Code Listing 4: Regularizing the format of the phone numbers

UPDATE michigan_park

SET description = REGEXP_REPLACE(description, 
    '([[:digit:]]{3})[-.]([[:digit:]]{3})[-.]([[:digit:]]{4})',
    '(\1) \2-\3');

E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy