SQL & PL/SQL

Hello,

I have something like:

    SELECT column_value,
            Count(column_value)
     FROM  (select column_value from table(apex_string.split('ENG - test1,ENG - test2,test,string', ',')))
GROUP  BY column_value
     HAVING Count(column_value) > 0;
    									

I don't know if it is possible using regular expressions, to split the string into rows, but only if the string starts with 3 capital letters followed by “-” (example ‘ENG - XXXX" or ’GER - XXXX'). So in the above example, “test,string" should not be splitted, but to appear in one row, as a column value.

So in that case 3 rows should be present:

ENG - test1

ENG - test2

test,string

How to achieve this using regular expressions?

Thanks!