Oracle fields query data by comma

The requirement is that the values stored in a field in a table are separated by commas, requiring that the data be traced against each of the separated values, but not using a like query.

The data is this:

The SQL for the query is as follows:

SELECT * FROM (    select GUIDs, Regexp_substr (st_responsible, ' [^,]+ ', 1, level) responsible from         Tt_cancle_ Responsible         connect by Level <= Regexp_count (st_responsible, ', ') + 1 and        GUID = Prior GUID and        prior Dbms_ Random.value is not null) where responsible = ' wyy ';

The query results are as follows:

Oracle fields query data by comma