today:
118
yesterday:
409
Total:
1,591,063

Technology

P59 - PL/SQL

admin 2019.05.28 21:00 Views : 370

select CONTRIBUTION_DATE,AMOUNT,m.MNAME,m.MKNAME from CONTRIBUTION c,MISSIONARY m 

where c.MISSIONARY_ID = m.MID AND

SUPPORTER_ID = :P59_SUPPORTER_ID

AND TO_NUMBER(TO_CHAR(CONTRIBUTION_DATE,'YYYY')) = :P59_YEAR