Hello there!
I need your experience to help me with a problem i have working with dates in Oracle 11gR2
If i use a table like:
| DATE | VALUE |
|---|
| 2014/06/07 | 100 |
| 2014/06/09 | 23 |
| 2014/06/14 | 32 |
| 2014/06/15 | 43 |
| 2014/06/17 | 54 |
i need a query to list all days and values between to dates (i.e. days between 2014/06/01 and 2014/06/20) and if a day is not registered it should be listed with value 0... the result should be the next:
| DATE | VALUE |
|---|
| 2014/06/01 | 0 |
| 2014/06/02 | 0 |
| 2014/06/03 | 0 |
| 2014/06/04 | 0 |
| 2014/06/05 | 0 |
| 2014/06/06 | 0 |
| 2014/06/07 | 100 |
| 2014/06/08 | 0 |
| 2014/06/09 | 23 |
| 2014/06/10 | 0 |
| 2014/06/11 | 0 |
| 2014/06/12 | 0 |
| 2014/06/13 | 0 |
| 2014/06/14 | 32 |
| 2014/06/15 | 43 |
| 2014/06/16 | 0 |
| 2014/06/17 | 54 |
| 2014/06/18 | 0 |
| 2014/06/19 | 0 |
| 2014/06/20 | 0 |
Is possible to do something like that in a query in Oracle 11gR2?
Thanx in advance for any help that u can give me.
best regards
Mauro!