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 |