today:
23,592
yesterday:
36,697
Total:
9,614,825

Oracle APEX SQL

SQL MISSIONARY_SUB

admin 2018.06.25 13:34 Views : 1206

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
42 PRICE TABLE UPDATE admin 2025.07.12 1539
41 Monthly SUM admin 2023.05.22 1522
40 LOOP TABLE UPDATE admin 2023.05.19 1624
39 STARTUP admin 2022.09.01 1150
38 ACTION admin 2019.01.11 7792
37 SELECT last_name FROM admin 2018.12.12 1969
36 CREATE TABLE admin 2018.09.25 1652
35 VERY IMPORTANT admin 2018.06.26 1310
» MISSIONARY_SUB admin 2018.06.25 1206
33 TABLE PRINT admin 2018.06.18 1357
32 GP PRINT admin 2018.05.31 2257
31 How to convert DATE to NUMBER admin 2018.05.27 1341
30 DATE Compare admin 2018.05.22 1514
29 Oracle SQL Developer: Online Migration 3.1 admin 2018.04.25 1441
28 How to Update Oracle XE admin 2018.04.25 1226
27 SQL admin 2016.07.15 1693
26 SUBSTR admin 2016.05.26 1340
25 FOR LOOP admin 2016.05.20 1490
24 ROWNUM admin 2016.05.19 1365
23 NVL admin 2016.05.19 1326
Write Tag