原表如下
select * from V_RES_CARD_LINKED
将列拆分成多行的语句
select REGEXP_SUBSTR(ASSET_CODE, '[^,]+', 1, L) AS ASSET_CODE,rackname,type from v_res_card_linked, (SELECT LEVEL L FROM DUAL CONNECT BY LEVEL <= 1000) WHERE L(+) <= LENGTH(ASSET_CODE) - LENGTH(REPLACE(ASSET_CODE, ',')) + 1
