1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| SQL> with t as (
2 select to_date('26/06/2012','dd/mm/yyyy') as dt, 2 as freq from dual union all
3 select to_date('26/06/2012','dd/mm/yyyy') as dt, 5 as freq from dual union all
4 select to_date('20/06/2012','dd/mm/yyyy') as dt, 5 as freq from dual union all
5 select to_date('22/06/2012','dd/mm/yyyy') as dt, 3 as freq from dual
6 ),
7 gen as (
8 select level as lvl from dual connect by level < 10
9 )
10 select *
11 from t
12 cross join gen
13 where trunc(dt+lvl*freq) = trunc(sysdate);
DT FREQ LVL
-------- ---------- ----------
26/06/12 2 1
22/06/12 3 2
SQL> |