select regexp_substr('11;22;33;44;55;','[^;]+',1,rownum)
from dual connect by rownum<=5
使用,pd_types为 【,11,21,22,23,44,31,32,】这种类型, 需要匹配为 【11,12】或者【31,32,33,44】
select *
from MMT_34_BRAND, (select level l_count from dual connect by level <= 20)
where regexp_substr(t.pd_types,'[^,]+',1,l_count ) in (11,12)