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
String splitting in plsql
Who is online
Users browsing this forum: No registered users and 33 guests