File indexing completed on 2024-04-06 12:22:58
0001
0002
0003
0004
0005
0006
0007
0008
0009 CREATE TABLE DCSLASTVALUE_VOLTAGE AS
0010 SELECT DISTINCT
0011 LOGIC_ID,
0012 VMON,
0013 SINCE
0014 FROM PVSS_HV_VMON_DAT
0015 WHERE VMON IS NOT NULL
0016 AND (LOGIC_ID, SINCE) IN
0017 (
0018 SELECT LOGIC_ID,
0019 MAX(SINCE)
0020 FROM PVSS_HV_VMON_DAT
0021 WHERE VMON IS NOT NULL
0022 GROUP BY LOGIC_ID
0023 )
0024 ORDER BY LOGIC_ID
0025 /
0026
0027 GRANT SELECT ON DCSLASTVALUE_VOLTAGE TO PUBLIC
0028 /
0029
0030 CREATE OR REPLACE TRIGGER PVSS_HV_VMON_DAT_INSERT
0031 BEFORE INSERT ON PVSS_HV_VMON_DAT
0032 FOR EACH ROW
0033 WHEN (NEW.VMON IS NOT NULL)
0034 DECLARE
0035 CHANGED_DP PVSS_HV_VMON_DAT.LOGIC_ID%TYPE;
0036 BEGIN
0037 UPDATE DCSLASTVALUE_VOLTAGE SET
0038 VMON = :NEW.VMON,
0039 SINCE = :NEW.SINCE
0040 WHERE LOGIC_ID = :NEW.LOGIC_ID
0041 RETURNING LOGIC_ID INTO CHANGED_DP;
0042 IF CHANGED_DP IS NULL THEN
0043 INSERT INTO DCSLASTVALUE_VOLTAGE VALUES
0044 (
0045 :NEW.LOGIC_ID,
0046 :NEW.VMON,
0047 :NEW.SINCE
0048 );
0049 END IF;
0050 END PVSS_HV_VMON_DAT_INSERT;
0051 /
0052