REATE OR REPLACE TRIGGER "WATCHDB"."TRIGGER_ON_INSERT" BEFORE INSERT ON "WATCHDB"."JBXX" REFERENCING OLD AS OLD NEW AS NEW FOR EACH ROW declare newid number;
begin
select count(*) into newid from jbxx;
insert into jbxxcs(lffh,id) values(:new.lffh,newid);
end;
问题描述如下:
表A的数据结构:
SQL> desc ainslabel
INSTCODE NOT NULL VARCHAR2(12)
MEASITEM NOT NULL NUMBER(2)
STARTVALUE NUMBER
ENDVALUE NUMBER
ENDTIME DATE
我在该表上建了一个触发器TRG_AINSLABEL
CREATE OR REPLACE TRIGGER "TRG_AINSLABEL" after
INSERT OR DELETEOR UPDATE OF "ENDTIME", "ENDVALUE", "INSTCODE", "MEASITEM", "STARTVALUE" ON "AINSLABEL" FOR EACH ROW
部分内容如下:
if inserting then
.....
select nvl(startvalue,0) into n_startvalue from ainslabel
where instcode = v_instcode and measitem=:new.measitem;
...
elsif updating then
....
select nvl(startvalue,0) into n_startvalue from ainslabel
where instcode = v_instcode and measitem=:new.measitem;
else
...
select nvl(startvalue,0) into n_startvalue from ainslabel
where instcode = v_instcode and measitem=:new.measitem;
...
end if;