String splitting in plsql

Oracle Application Express is a rapid development tool for Web applications on the Oracle database.
Post Reply
admin
Posts: 2063
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

String splitting in plsql

Post by admin »

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
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests