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 identify non numeric characters

524303Oct 3 2006 — edited Nov 3 2010

Hi ,

Is there a way to write a sql query to identify only the rows of a field that has non numeric characters.

Ex:

Column A
100
one
150/20
two
twenty two
300

Is there a way to write a SQL stmt to filter out only non numeric characters of this column to output

Col A
one
two
twenty two

Thanks in advance for your help.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 2 2006

Added on Oct 3 2006

11 comments

3,720 views