view.sql

来自「linux下c 编写的 某项目代理服务端部分的代码。其中包括网络通信」· SQL 代码 · 共 31 行

DROP DATABASE LINK OMC.world;
CREATE DATABASE LINK OMC.world
CONNECT TO OMC IDENTIFIED BY OMC USING 'WGNOKIA';


CREATE OR REPLACE VIEW V_FX_ALARM
AS SELECT a.CONSEC_NBR       
	  ,a.INT_ID           
	  ,DECODE(a.ALARM_STATUS,'0','2','1') ALARM_STATUS 
	  ,a.ALARM_TIME       
	  ,a.CANCEL_TIME      
	  ,decode(to_char(a.ALARM_NUMBER),'7401','01','7402','08','7403','10','7404','11','7405','06','7406','07','00') ALARM_NUMBER
	  ,DECODE(a.SEVERITY,'1','1') SEVERITY
	  ,b.NAME
   FROM [e-mail] a,[e-mail] B
   WHERE  a.INT_ID=b.INT_ID
   AND a.ALARM_NUMBER >= 7401
   AND a.ALARM_NUMBER <= 7408;


c_bcf
.int_id
.conf——name='<actual>'


交流断电
交流缺相
交流过压
直流欠压
高温
门禁