String splitting in plsql
Posted: Mon Nov 23, 2015 4:41 am
DECLARE
ARRAY apex_application_global.vc_arr2;
BEGIN
ARRAY := apex_util.string_to_table('ERPstuff.com,info@erpstuff.com',','); --Comma is used to split and if space is there for splitting then it will be ' '.
FOR i IN 1..ARRAY.COUNT LOOP
DBMS_OUTPUT.PUT_LINE(ARRAY(I));
END LOOP;
END;
--Output
ERPstuff.com
info@erpstuff.com
ARRAY apex_application_global.vc_arr2;
BEGIN
ARRAY := apex_util.string_to_table('ERPstuff.com,info@erpstuff.com',','); --Comma is used to split and if space is there for splitting then it will be ' '.
FOR i IN 1..ARRAY.COUNT LOOP
DBMS_OUTPUT.PUT_LINE(ARRAY(I));
END LOOP;
END;
--Output
ERPstuff.com
info@erpstuff.com