?? 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 + -