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!

How to Remove Alpha characters using sql

user13034857Sep 6 2013 — edited Sep 6 2013

Hello all,

I have to remove alpha characters in my data

for example

305N -->305

I want to remove using regexp_replace function

select regexp_REPLACE('305N','[:alpha:]','') NUM from Dual;

Please suggest me.

Thanks in advance.

This post has been answered by Frank Kulash on Sep 6 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 4 2013

Added on Sep 6 2013

#sqlplus

3 comments

6,982 views