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!

Regular Expression Numeric characters only

Johnbr (Oracle10G)Nov 26 2012 — edited Nov 26 2012

Hi All,

I'm trying to select just the numeric characters only. However, this regexpression returns data that also has a - in it or alpha characters, such as 58-69-30-008 NWSE. I don't want this.

I just want rows with ONLY numeric data.

WHERE servloc like '%[0-9]%'

Thanks for your help,

John

This post has been answered by Solomon Yakobson on Nov 26 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 24 2012

Added on Nov 26 2012

4 comments

259 views