ors_bb.sql

来自「主要 用于通知故障现场通过短信的方式对技术员工提供处理故障的信息」· SQL 代码 · 共 41 行

CREATE OR REPLACE PROCEDURE CP_ors_bb(
clr IN VARCHAR,
begintime IN VARCHAR,
endtime IN VARCHAR,
rep_cursor OUT C112_DT.CurTyp
)

AS


BEGIN
       IF clr = '' THEN
           BEGIN
                  open rep_cursor FOR 
                  SELECT * FROM ors_ldrecord WHERE to_char(recepttime,'yyyy-mm-dd')
                  bewteen begintime and endtime;                  
           END;
           ELSE
           BEGIN
                  open rep_cursor for
                  SELECT * FROM ors_ldrecord WHERE to_char(recepttime,'yyyy-mm-dd')
                  bewteen begintime AND endtime AND dealoper = clr;
           END;
       END IF;
       
END;
/
show erroes;



select to_char(a.dealtime,'yyyy-mm-dd'),to_char(a.dealtime,'hh24:mi:ss'),
c.descript,d.descript,a.dealresult 
from ors_lddisprecord a,ors_zyxmcode c,ors_zyxmcode d 
where a.dealoper = :li_oper 
and to_char(a.dealtime,'yyyy-mm-dd') between :ls_time1 and :ls_time2 
and a.curstate < 5 and a.zyxm = c.intid and c.subflag = 1 
and c.operator = :li_oper 
and a.subzyxm = d.intid and d.subflag = 2 and d.operator = :li_oper 
order by to_char(a.dealtime,'yyyy-mm-dd'),to_char(a.dealtime,'hh24:mi:ss')