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!

Find Numbers In Varchar Field

we44748079Mar 26 2014 — edited Mar 26 2014

I have a Varchar2 column for data cleaning I wish to find following is that column:

1. pure numbers i.e.

122

33445

2. Number with spaces i.e.

222 3333

3 11

3. Data with no alphabet (not in a to z or A to Z) i.e

11-3334-22

33&&44

11/99

Can some one please provide me above the quires?

thanks
J a w a d

This post has been answered by Partha Sarathy S on Mar 26 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 23 2014

Added on Mar 26 2014

#9i

7 comments

1,444 views