insert into PROD.TBL_PROD_ME (MNTH,HOURS_NOHOURS,NAME,TOTAL_STFD_TIME,COLLECTOR,COMMENT_ADDED_ID,CALLS,CONTACTS,PROM_TO_PAY,KEPT,SUPERVISOR)
SELECT MNTH,
HOURS_NOHOURS,
NAME,
sum(case
when TOTAL_STFD_TIME is null then 0
else to_number(TOTAL_STFD_TIME)
end)...