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!

To select only Numeric data from a column

2652054Apr 25 2018 — edited Mar 1 2019

Hi All,

I have a column in my table <colm1> which has alphanumeric data like 123,abc,123abc,234,bcd,234bcd. I have a requirement where I need to select only the numeric data (only 123,234 etc) from this table.

If possible can you guide me on how to achieve it ?

Regards,

This post has been answered by Gaz in Oz on Apr 25 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 25 2018

Added on Apr 25 2018

15 comments

6,443 views