today:
88
yesterday:
225
Total:
1,002,440

SQL MISSIONARY_SUB

admin 2018.06.25 13:34 Views : 199

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 SQL Developer Password change / EXPORT & IMPORT admin 2022.03.18 157
65 DELETE PROCESS admin 2016.04.28 158
64 INSERT PROCESS admin 2016.04.28 160
63 SQL SELECT DISTINCT Statement admin 2016.04.29 161
62 JAVA for delete admin 2016.04.28 162
61 Delete Message - Are you sure you want to delete this object? admin 2016.04.28 166
60 TAP ( Main & Sub ) / Button 의 Switch admin 2016.04.28 166
59 UPDATE PROCESS admin 2016.04.28 167
58 CREATING A TABLE / SEQUENCE / TRIGGER admin 2016.04.28 172
57 EXPORT & IMPORT admin 2016.05.01 174
56 CREATE TABLESPACE admin 2016.04.28 177
55 Captcha Test file admin 2016.04.18 178
54 Apex setup procedure admin 2016.04.28 182
53 TABLE PRINT admin 2018.06.18 186
52 How to convert DATE to NUMBER admin 2018.05.27 198
» MISSIONARY_SUB admin 2018.06.25 199
50 Name Show admin 2016.04.28 203
49 use a validation function for an element in apex 5.0 admin 2018.05.19 209
48 IF/ELSE ... CASE WHEN admin 2018.06.25 209
47 All Data DELETE from Table admin 2018.05.10 211
Write Tag