Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

format phone number

JonMaximusJun 2 2015 — edited Jun 2 2015

I need to format phone number in a table column like phone_number to

(+1-888-888-8888 ) to (888)888-8888


is there a function or query in oracle to do this.  Help is appreciated

This post has been answered by Karthick2003 on Jun 2 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 30 2015
Added on Jun 2 2015
18 comments
4,497 views