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
ORA-00904: "SALES": invalid identifier
ORA-00904: "PRICE": invalid identifier
ORA-00904: "PRICE": invalid identifier
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 |