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!

regexp_like for alphanumeric

2726960Aug 5 2014 — edited Aug 6 2014

Hi,

My apologies if this is a repeat. I struggle with Regular Expressions and this requirement that I have is turning into a nightmare.

here is what i am trying to do.

I have a table with a column that holds values ranging from 5digits / 4digits+1alpha / 10digits / 5letter strings. I am trying to curate the table down to a table with only alpha strings.

This is getting really beyond my capabilities can anyone help?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 3 2014
Added on Aug 5 2014
7 comments
5,056 views