procedure_5

来源：互联网发布：linux上装eclipse 编辑：程序博客网时间：2024/06/16 05:20

exception
     when others then
       open p_cur for
             select 1 DTIME,
                    cast('err' as varchar2(128)) TEST1,
                    cast('err' as varchar2(128)) TEST2,
                    cast('err' as varchar2(128)) TEST3,
                    cast('err' as varchar2(128)) TEST4,
                    cast('err' as varchar2(128)) TEST5,
                    cast('err' as varchar2(128)) TEST6,
                    cast('err' as varchar2(128)) TEST8,
                    cast('err' as varchar2(128)) TEST9,
                    cast('err' as varchar2(128)) TEST10
               from dual;
end p_test;

----最近31天填空
select to_char (sysdate-rownum, 'yyyymmdd') dtime,
        0 test1,0 test2 ,0 test3
        from dual connect by rownum <=31
----最近4周填空
select to_char(sysdate-7*rownum,'yyyyiw') dtime,
          0 test1,0 test2 ,0 test3
          from dual connect by rownum <=4
----最近12个月填空
select to_char(add_months(sysdate,-rownum),'yyyymm') dtime,
        0 test1,0 test2 ,0 test3
        from dual connect by rownum <=12
--p_time过程的全局变量，v_endtime局部变量
v_endtime := 'to_date('''||p_time||''',''yyyymmdd'')';

select
next_day(trunc(to_date(substr('201502',1,4),'yyyy'),'YYYY'),7) + substr('201502',5,6) * 7 - 6
from dual--201502表示2015年第二周，2015年第二周的最后一天按自然周

select
last_day(trunc(add_months(to_date('201503','yyyymm'),0),'mm'))
from dual--该201503月的最后一天

0 0