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;
?
发布时间： 2013-07-09 09:50:47 作者： rapoo
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;
?