Hello,
I need help with Oracle Regex please. I need to split the string that looks like this: "0123840000BLAH BLAH blah (blah)" into digits and alpha. Some data will not have brackets, only words. The following gives me only the first BLAH:
SELECT REGEXP_SUBSTR('0123840000BLAH BLAH blah (blah)', '[[:alpha:]]+') AS alpha_only
FROM dual
/
OR
SELECT REGEXP_SUBSTR('0123840000BLAH BLAH blah', '[[:alpha:]]+') AS alpha_only
FROM dual
/
Is there a way to get the whole string after last digit without looping with level and connect by please? Again, some data has brackets and some does not.
Thank you very much to all,
Art.