today:
291
yesterday:
456
Total:
1,015,617

SQL MISSIONARY_SUB

admin 2018.06.25 13:34 Views : 213

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
46 DATE Compare admin 2018.05.22 379
45 How to convert DATE to NUMBER admin 2018.05.27 207
44 GP PRINT admin 2018.05.31 930
43 TABLE PRINT admin 2018.06.18 203
42 eeeeee admin 2018.06.21 238
» MISSIONARY_SUB admin 2018.06.25 213
40 IF/ELSE ... CASE WHEN admin 2018.06.25 218
39 VERY IMPORTANT admin 2018.06.26 241
38 Change Admin PASSWORD admin 2018.07.31 247
37 CREATE TABLE admin 2018.09.25 484
36 IMP admin 2018.10.08 739
35 SELECT last_name FROM admin 2018.12.12 759
34 ACTION admin 2019.01.11 6468
33 JK admin 2019.02.05 713
32 QRCODE admin 2020.05.25 409
31 How to Install Oracle 11g on Windows 10 - 64 bit | Download / Install Oracle 11g Database file admin 2022.03.17 127
30 SQL DEVELOPER file admin 2022.03.17 115
29 Forgot Oracle username and password, how to retrieve? admin 2022.03.18 157
28 SQL Developer Password change / EXPORT & IMPORT admin 2022.03.18 163
27 STARTUP admin 2022.09.01 98
Write Tag