--周列表
select ww, '第'|| ROWNUM || '周' from
(select distinct (to_char(dt, 'yyiw')) ww
from (
select (to_date('2005-01-01', 'yyyy-mm-dd') + rownum - 1) dt
from dual
connect by rownum <= to_date('2008-12-30', 'yyyy-mm-dd') -
to_date('2005-01-01', 'yyyy-mm-dd') + 1
)
ORDER BY to_char(dt, 'yyiw')
) aa
--月列表
select distinct(to_char(dt,'yyyymm')) from (
select (to_date('2005-01-01', 'yyyy-mm-dd')+rownum-1) dt from dual
connect by rownum<=to_date('2008-12-30', 'yyyy-mm-dd')-to_date('2005-01-01', 'yyyy-mm-dd') + 1
)
ORDER BY to_char(dt,'yyyymm')
--日列表
select (to_date('2005-01-01', 'yyyy-mm-dd')+rownum-1) dt from dual
connect by rownum<=to_date('2008-12-30', 'yyyy-mm-dd')-to_date('2005-01-01', 'yyyy-mm-dd') + 1
--得到某一用户下的所有表名
select * from all_tables where owner='用户名';