driver对应触发器.docVIP

driver对应触发器 ---原始表 CREATE TABLE ST_RIVER_R_T ( STCD VARCHAR2(8) NOT NULL, TM DATE NOT NULL, Z NUMBER(7,3), Q NUMBER(9,3), XSA NUMBER(9,3), XSAVV NUMBER(5,3), XSMXV NUMBER(5,3), FLWCHRCD VARCHAR2(1), WPTN VARCHAR2(1), MSQMT VARCHAR2(1), MSAMT VARCHAR2(1), MSVMT VARCHAR2(1), MDA VARCHAR2(1), RDTM DATE, INDBTM DATE, PRIMARY KEY (STCD,TM,MDA) ); --原始表触发器 CREATE OR REPLACE TRIGGER SYN_I_ST_RIVER_R_T AFTER INSERT ON ST_RIVER_R_T FOR EACH ROW BEGIN INSERT INTO SYN_ST_RIVER_R_T VALUES(:NEW.STCD,:NEW.TM,:NEW.Z,:NEW.Q,:NEW.XSA,:NEW.XSAVV,:NEW.XSMXV,:NEW.FLWCHRCD, :NEW.WPTN,:NEW.MSQMT,:NEW.MSAMT,:NEW.MSVMT,:NEW.MDA,:NEW.RDTM,:NEW.INDBTM,I); END; INSERT INTO ST_RIVER_R_T VALUES(r01,SYSDATE,1,1,1,1,1,1,1,1,1,1,1,SYSDATE,SYSDATE); INSERT INTO ST_RIVER_R_T VALUES(r02,SYSDATE,1,1,1,1,1,1,1,1,1,1,1,SYSDATE,SYSDATE); INSERT INTO ST_RIVER_R_T VALUES(r03,SYSDATE,1,1,1,1,1,1,1,1,1,1,1,SYSDATE,SYSDATE); INSERT INTO ST_RIVER_R_T VALUES(r04,SYSDATE,1,1,1,1,1,1,1,1,1,1,1,SYSDATE,SYSDATE); INSERT INTO ST_RIVER_R_T VALUES(r05,SYSDATE,1,1,1,1,1,1,1,1,1,1,1,SYSDATE,SYSDATE); INSERT INTO ST_RIVER_R_T VALUES(r06,SYSDATE,1,1,1,1,1,1,1,1,1,1,1,SYSDATE,SYSDATE); --原始表临时表 CREATE TABLE SYN_ST_RIVER_R_T ( STCD VARCHAR2(8) NOT NULL, TM DATE NOT NULL, Z NUMBER(7,3), Q NUMBER(9,3), XSA NUMBER(9,3), XSAVV NUMBER(5,3), XSMXV NUMBER(5,3), FLWCHRCD VARCHAR2(1), WPTN VARCHAR2(1), MSQMT VARCHAR2(1), MSAMT VARCHAR2(1), MSVMT VARCHAR2(1), MDA VARCHAR2(1), RDTM DATE, INDBTM DATE, flag varchar(1), PRIMARY KEY (STCD,TM,MDA) ); --业务表数据整理 CREATE TABLE ST_RIVER_R ( STCD VARCHAR2(8) NOT NULL, TM DATE NOT NULL, Z NUMBER(7,3), Q NUMBER(9,3), XSA NUMBER(9,3), XSAVV NUMBER(5,3), XSMXV NUMBER(5,3), FLWCHRCD VARCHAR2(1)