Skip to Main Content

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!

Getting non numeric strings using regular expression

1047637Jan 10 2014 — edited Jan 10 2014

Hi Guys ,

I  want to get list of string values in table which contains no numeric values  .....

I have a   string column name A and table name B  .

I have written following code , but it seems it is incorrect  .

Plz help me out  .....

 

SELECT

A FROM

B

 

WHERE

regexp_like(A, '([^[:digit:]])'

)

Thanks in advance ....

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 7 2014
Added on Jan 10 2014
6 comments
4,238 views