today:
1,157
yesterday:
1,189
Total:
1,008,537

SQL MISSIONARY_SUB

admin 2018.06.25 13:34 Views : 202

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
66 UPDATE PROCESS admin 2016.04.28 168
65 Delete Message - Are you sure you want to delete this object? admin 2016.04.28 166
64 JAVA for delete admin 2016.04.28 165
63 SQL SELECT DISTINCT Statement admin 2016.04.29 162
62 DELETE PROCESS admin 2016.04.28 161
61 INSERT PROCESS admin 2016.04.28 160
60 SQL Developer Password change / EXPORT & IMPORT admin 2022.03.18 157
59 MAX admin 2016.04.28 156
58 wwv_flow_files admin 2016.05.01 155
57 PHONE NUMBER admin 2016.04.28 154
56 Column Data 일괄 추가 admin 2023.11.24 152
55 Forgot Oracle username and password, how to retrieve? admin 2022.03.18 152
54 NVL admin 2016.05.19 152
53 CREATE (INSERT) PROCESS admin 2016.04.28 152
52 COUNT admin 2016.04.28 149
51 Field Showing admin 2016.04.01 149
50 Outer Join with Oracle SQL admin 2016.04.29 148
49 BOOLEAN SAMPLE admin 2016.05.11 147
48 Delimiter admin 2016.04.29 142
47 How to Update Oracle XE admin 2018.04.25 141
Write Tag