SELECT DISTINCT regexp_substr(a.sbhdxh,'[^,]+', 1, level) from (SELECT sbhdxh FROM hddyb WHERE instr(sbhdxh,',')>0) a
connect by regexp_substr(a.sbhdxh, '[^,]+', 1, level) is not NULL
connect by regexp_substr(a.sbhdxh, '[^,]+', 1, level) is not NULL