17,086
社区成员
发帖
与我相关
我的任务
分享
declare
collect_time date:=sysdate;
jieguo number;
begin
execute immediate 'select count(*) from std_fmdb.tfa_alarm_act
WHERE event_time > '||collect_time+||'-1/24
AND city_name IS NOT NULL
AND org_severity IS NOT NULL
AND professional_type IS NOT NULL
AND vendor_name IS NOT NULL
AND eqp_object_class IN(101,102,130,131,200) '
into jieguo;
dbms_output.put_line(jieguo);
end;