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;