Hi,
I'm using oracle 11g. I must create a query who creates a table with a range of dates starting by a table with a single dates' field.
Example:
Legislature |
|---|
| 29-apr-08 |
| 28-apr-06 |
| 30-may-01 |
| inter |
|---|
| 15-may-09 |
| 29-apr-07 |
30-jul-05 |
| 16-jun-10 |
Result
| date_from | date_to | count |
|---|
| 29-apr-08 | sysdate | 2 |
| 28-apr-06 | 28-apr-08 | 1 |
| 30-may-01 | 27-apr-08 | 1 |