Skip to Main Content
Forums

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!

Remove special characters and spaces.

KkiNov 14 2014 — edited Nov 14 2014

Hi All,

Below is the phone table having one column that is “phno” and values are the below in this format.

I need given output .

My client is using oracle 8i version.

emplid

Phno

output

121212

605/339- 9276

6053399276

222222

813/251-0663

8132510663

323232

208 585 1594

2085851594

232323

352.735.8285

3527358285

Thanks,

kki
This post has been answered by Frank Kulash on Nov 14 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 12 2014
Added on Nov 14 2014
5 comments
547 views