select *
from (select REGEXP_SUBSTR(sp.str, '[^,]+', 1, rownum) as tt
from dual,(select '陈仓区支行,汉滨区支行,3' str from dual) sp
CONNECT BY ROWNUM <=
LENGTH(sp.str) -
LENGTH(REPLACE(sp.str, ',', '')) + 1)