add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
5 rows affected
CUSTOMER_NO ACCOUNT_NO SUM(ACCOUNTED_DR) SUM(ACCOUNTED_CR) Effective Months and Years
5010011 19 141.23 0 2021-01
5010011 19 16 0 2021-02
5010011 27 130500 0 2021-02
ORA-01738: missing IN keyword
CUSTOMER_NO ACCOUNT_NO 2021/01_DR 2021/01_CR 2021/02_DR 2021/02_CR 2021/03_DR 2021/03_CR 2021/04_DR 2021/04_CR 2021/05_DR 2021/05_CR 2021/06_DR 2021/06_CR
5010011 19 141.23 0 16 0 null null null null null null null null
5010011 27 null null 130500 0 null null null null null null null null
CUSTOMER_NO ACCOUNT_NO 2021/01_DR 2021/01_CR 2021/02_DR 2021/02_CR 2021/03_DR 2021/03_CR 2021/04_DR 2021/04_CR 2021/05_DR 2021/05_CR 2021/06_DR 2021/06_CR
5010011 19 141.23 0 16 0 null null null null null null null null
5010011 27 null null 130500 0 null null null null null null null null