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 to find pattern starting with characters

643308Jun 10 2009 — edited Jun 10 2009

Hi,

I have requirement to differentiate a varchar column which holds records in below pattern(combiination of numeric and alphabets,expression can start with any alphabets/numeric but both don't mix up like "xc12df").
col1
----------
abc123
1234.abc
1234
xbc

I want the output as expression starting with alphabet and expression starting with number to be differentiated.
i m using below for finding all records starting with alphabets
REGEXP_LIKE(col1,^[alpha])

but its not workin for me
Can anyone help on this/ or can tel any other way to do this

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 8 2009

Added on Jun 10 2009

6 comments

6,135 views