存储过程

最新推荐文章于 2022-04-28 15:35:13 发布

qq_31197461

最新推荐文章于 2022-04-28 15:35:13 发布

阅读量257

点赞数 1

分类专栏： java工程的那点小 oracle存储过程文章标签：存储

本文链接：https://blog.csdn.net/qq_31197461/article/details/67640656

版权

java工程的那点小同时被 2 个专栏收录

5 篇文章 0 订阅

订阅专栏

oracle存储过程

3 篇文章 0 订阅

订阅专栏

create or replace procedure getalert
as
begindate number(20);
enddate number(20);
begin

  begindate:=get_millisecond(to_date(to_char(sysdate-1,'yyyy-mm-dd'),'yyyy-mm-dd'))+8*60*60*1000;
  enddate:=get_millisecond(to_date(to_char(sysdate,'yyyy-mm-dd'),'yyyy-mm-dd'))+8*60*60*1000;
   insert into alert_analysis_fact (moname,time_id,ackoprter,clroprter,category,alertnum)
  select fm.moname,
         fm.occurtime,
         fm.ackoprter,
         fm.clroprter,
         fm.category,
          count(fm.eventid)
    from fm_alert  fm
   where fm.occurtime > to_number(begindate)
     and fm.occurtime <to_number(enddate)

  union all
  select fah.moname,
         fah.occurtime,
         fah.ackoprter,
         fah.clroprter,
         fah.category,
         count(fah.eventid)
    from fm_alert_history  fah
   where fah.occurtime >to_number(begindate)
     and fah.occurtime <to_number(enddate);

end getalert;