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.