DECLARE
TESTEMAIL VARCHAR2(100);
EMAIL_LIST VARCHAR2(100);
EMAIL_COUNT NUMBER;
BEGIN
SELECT COUNT(*) INTO EMAIL_COUNT FROM TEST_EMAIL;
FOR i IN 1..EMAIL_COUNT
LOOP
SELECT TESTEMAIL INTO EMAIL_LIST FROM TEST_EMAIL WHERE ID = i;
APEX_MAIL.SEND(
p_to => EMAIL_LIST ,
p_from => 'admin@solatoz.com',
p_subj => 'APEX_MAIL admin@solatoz.com - 12/8/2018...6:51PM',
p_body => 'Please Check email.',
p_body_html => '<b>UTL_SMTP network allow</b>&TESTEMAIL. New email account... 12/8/2018...6:51PM ...HOME '
);
END LOOP;
END;