Hello
can you please help me how to create a PL/SQL process to insert only rows which has values from tabular form into database,not those rows which does not have value, below is the insert PL/SQL process that i created, but it insert empty rows also, which did not have value.


begin

FOR i in 1..APEX_APPLICATION.G_F05.COUNT LOOP

IF APEX_APPLICATION.G_F05(i) > 1 THEN
insert into TBL_MEETING_LOAN (PROFIT) values (:DERIVED$05);
END IF;

END LOOP;

End;



please check below pictures.

values while entry.
http://i.stack.imgur.com/D49DS.jpg


database after insert.
http://i.stack.imgur.com/Yfu1Y.jpg

begin

  FOR i in 1..APEX_APPLICATION.G_F05.COUNT LOOP

    IF APEX_APPLICATION.G_F05(i) > 1 AND :DERIVED$05 IS NOT NULL THEN
      insert into TBL_MEETING_LOAN (PROFIT) values (:DERIVED$05);
    END IF;

  END LOOP;

End;
/

begin

  forall i in 1..apex_application.g_f05.count 
    insert into tbl_meeting_loan (profit) 
      select :derived$05
      from   dual
      where  apex_application.g_f05(i) > 1 
      and    :derived$05 is not null;
    
end;
/