📄 view.sql
字号:
DROP DATABASE LINK OMC.world;CREATE DATABASE LINK OMC.worldCONNECT TO OMC IDENTIFIED BY OMC USING 'WGNOKIA';CREATE OR REPLACE VIEW V_FX_ALARMAS 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 FX_ALARM@OMC.WORLD a,OBJECTS@OMC.WORLD 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>'交流断电交流缺相交流过压直流欠压高温门禁
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -