Oracle 字符串瓜分 Split

2013-07-09

Oracle 字符串分割SplitSELECT * FROM TABLE(F_SPLIT_STRING(1,2,3,4,5,6,,))DECLAREV_ARRAY T_RET_TA

Oracle 字符串分割 Split
SELECT * FROM TABLE(F_SPLIT_STRING('1,2,3,4,5,6',','))DECLARE V_ARRAY T_RET_TABLE;BEGIN V_ARRAY := F_SPLIT_STRING('1,2,3,4,5,6',','); FOR I IN 1..V_ARRAY.COUNT LOOP DBMS_OUTPUT.PUT_LINE(V_ARRAY(i)); END LOOP;END;