Skip to Main Content
Forums

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 not returning expected results

615711Sep 10 2009 — edited Sep 10 2009
My first attempt at REGEXP_LIKE and I'm obviously missing something. I've tried several suggestions I found in the forum but cannot get the correct results. I need the following query to return only those rows containing only alphabetic characters (no numbers). What I get are rows containing letters and numbers.

Any help will be greatly appreciated!

Randy

SELECT order_number
FROM order_table
where REGEXP_LIKE(order_number,'[a-z A-Z
This post has been answered by MichaelS on Sep 10 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 8 2009
Added on Sep 10 2009
#pl-sql
5 comments
2,500 views