现在知道了列出指定某一天的前一个星期的日期这样写:
select
to_date('2006-02-23', 'yyyy-mm-dd') - rownum + 1 dt
from dual
connect by rownumselect
2to_date('2006-02-23', 'yyyy-mm-dd') - rownum + 1 dt
3from dual
4connect by rownumSELECT to_char( days.day + to_date('21-11-2004','DD-MM-YYYY'),'DAY') day
2FROM ( select rownumday
3 from ( select 1
4
from dual
5
group
6
by cube (1,2,3)
7
)
8 where rownum select * from (SELECT TO_DATE('2006-04-23', 'yyyy-mm-dd') - ROWNUM + 1
2FROM dual CONNECT BY ROWNUMSELECT 1 FROM dual GROUP BY CUBE (1,2,3,4);
1
----------
1
已选择 1 行。
SQL> select * from
2(SELECT 1 FROM dual GROUP BY CUBE (1,2,3,4));
1
----------
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
已选择16行。
|