By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
PRODUCT_ID | '01-MAY-2015' | '02-MAY-2015' |
---|---|---|
PROD1 | 125 | 10 |
PROD4 | null | 120 |
PROD3 | 250 | 125 |
PROD5 | null | 50 |
PROD2 | 20 | 40 |
PROD6 | null | 100 |
PRODUCT_ID | TO_DATE(' 2015-05-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss') | TO_DATE(' 2015-05-02 00:00:00', 'syyyy-mm-dd hh24:mi:ss') |
---|---|---|
PROD1 | 125 | 10 |
PROD4 | null | 120 |
PROD3 | 250 | 125 |
PROD5 | null | 50 |
PROD2 | 20 | 40 |
PROD6 | null | 100 |
PRODUCT_ID | May01 | May02 |
---|---|---|
PROD1 | 125 | 10 |
PROD2 | 20 | 40 |
PROD3 | 250 | 125 |
PROD4 | null | 120 |
PROD5 | null | 50 |
PROD6 | null | 100 |