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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to use REGEXP_LIKE

ScottintexasDec 13 2022

I have no experience with Oracle's SQL REGEXP_LIKE and want to use it (or an alternative) to find all records in a table named Result that match \d{6,7}-\d{7}
That pattern does not seem to work. I have millions of records, but that should have retrieved some in the time it was grinding away. This is an example of a result name I am looking for in the table. 1234567-1234567_1234-abcd and some other stuff
I could not figure it out from Oracle's discussion on Using Regular Expressions (https://docs.oracle.com/cd/B13789_01/appdev.101/b10795/adfns_re.htm)
Can someone help with this?

Thank you.

This post has been answered by mathguy on Dec 13 2022

Jump to Answer

Added on Dec 13 2022

5 comments

1,988 views

1 mention