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!

Function to extract only numeric value

585975Dec 10 2007 — edited Mar 14 2013

Hi

I have a column which contains alphanumeric number like LAX4308720

Is there any function in oracle so that I could extract only the numeric values like
4308720 from that string..?

Please provide me some solutions

Shelly

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 11 2013

Added on Dec 10 2007

#11g, #dba, #query

14 comments

2,672 views