20170502 oracle 利用dual 构造 生成 一张表

  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)