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!

Extract number value from string

599314Dec 12 2007 — edited May 11 2011
Hi,

I am getting a string value like bellow.

'2222jhone'

'123344Sam'

'11Tim'

i want to extract only number value.Can anybody help to prepare reg expression.

Tahnks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 8 2011
Added on Dec 12 2007
15 comments
69,662 views