This thread is continued from
1056886
select * from v$version;
BANNER
-------------------------------------------------------
Oracle Database 11g Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
with rec(dayc,LV) as(
select cast(date '2010-04-15' as date),1 from dual
union all
select cast(dayc+1 as date),LV+1
from rec
where LV<= 3)
select * from rec;
DAYC LV
-------- ---------
10-04-15 1
10-04-14 2
10-04-13 3
10-04-12 4
Why column DAYC is decreased ?
I think correct resultSet is below
DAYC LV
-------- ---------
10-04-15 1
10-04-16 2
10-04-17 3
10-04-18 4