today:
1,051
yesterday:
1,189
Total:
1,008,431

SQL MISSIONARY_SUB

admin 2018.06.25 13:34 Views : 201

insert into MISSIONARY_SUB
Select 
MISSIONARY_ID,SUPPORTER_ID,AMOUNT,CONTRIBUTION_DATE 
from CONTRIBUTION 
where UPPER(:P9_MISSIONARY_ID) = MISSIONARY_ID 
and :P9_YEAR = to_number(to_char(CONTRIBUTION_DATE,'YYYY'))
order by SUPPORTER_ID,CONTRIBUTION_DATE;
I want to
List
No. Subject Author Date Views
126 ACTION admin 2019.01.11 6458
125 Fundamentals of PL/SQL admin 2016.05.10 2041
124 QR Code plugin admin 2017.11.30 1589
123 QR Code plugin Process admin 2017.11.30 964
122 How to Update Oracle XE Version admin 2018.02.23 932
121 GP PRINT admin 2018.05.31 921
120 INSTR admin 2016.05.19 791
119 SELECT last_name FROM admin 2018.12.12 745
118 IMP admin 2018.10.08 725
117 TREE admin 2016.05.18 722
116 JK admin 2019.02.05 703
115 CREATE TABLE admin 2018.09.25 471
114 APEX Password Change admin 2016.08.26 463
113 Membership Management admin 2016.06.09 435
112 JavaScript for Member List admin 2016.08.17 434
111 QRCODE admin 2020.05.25 405
110 control break admin 2016.06.25 399
109 SQL admin 2016.07.15 397
108 DATE Compare admin 2018.05.22 369
107 APEX Web Services Proxy Settings admin 2016.06.07 361
Write Tag