oracle中得到一段时间内天，月，周列表

--周列表
 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='用户名';