CREATE TRIGGER FOXMOLD.WORKTB_MODIFY_NEW_TESTTRIGGER1
before INSERT ON FOXMOLD.WORKTB_MODIFY_NEW_TEST
FOR EACH ROW
DELARE
NUM VARCHAR2;
BEGIN
SELECT COUNT(EMP_NO) INTO NUM FROM EMPLOYMENT_TEST
WHERE EMP_NO=:NEW.EMP_NO
AND TO_CHAR(WHAT_DATE,'YYYYMMDD')=CONCAT(CONCAT
(:NEW.YEAR,:NEW.MONTH),:NEW.DAY);
IF NUM>0 THEN
IF CONCAT(CONCAT(:NEW.YEAR,:NEW.MONTH),:NEW.DAY)<TO_CHAR
(SYSDATE,'YYYYMMDD') THEN
update employment_test set work_style=:new.id_class
where emp_no=:new.emp_no
and to_char(what_date,'yyyymmdd')=
concat(concat(:new.year,:new.month),:new.day);
END IF;
END IF;
END;
before INSERT ON FOXMOLD.WORKTB_MODIFY_NEW_TEST
FOR EACH ROW
DELARE
NUM VARCHAR2;
BEGIN
SELECT COUNT(EMP_NO) INTO NUM FROM EMPLOYMENT_TEST
WHERE EMP_NO=:NEW.EMP_NO
AND TO_CHAR(WHAT_DATE,'YYYYMMDD')=CONCAT(CONCAT
(:NEW.YEAR,:NEW.MONTH),:NEW.DAY);
IF NUM>0 THEN
IF CONCAT(CONCAT(:NEW.YEAR,:NEW.MONTH),:NEW.DAY)<TO_CHAR
(SYSDATE,'YYYYMMDD') THEN
update employment_test set work_style=:new.id_class
where emp_no=:new.emp_no
and to_char(what_date,'yyyymmdd')=
concat(concat(:new.year,:new.month),:new.day);
END IF;
END IF;
END;
CREATE TRIGGER FOXMOLD.WORKTB_MODIFY_NEW_TESTTRIGGER1 AFTER INSERT
ON FOXMOLD.WORKTB_MODIFY_NEW_TEST
FOR EACH ROW
DELARE
NUM VARCHAR2;
BEGIN
IF :NEW.YEAR||:NEW.MONTH||:NEW.DAY<TO_CHAR(SYSDATE,'YYYYMMDD') THEN
update employment_test set work_style=:new.id_class
where emp_no=:new.emp_no
and to_char(what_date,'yyyymmdd')=:new.year||:new.month||:new.day;
END IF;
END;
/
CREATE TRIGGER FOXMOLD.WORKTB_MODIFY_NEW_TESTTRIGGER1 AFTER INSERT
ON FOXMOLD.WORKTB_MODIFY_NEW_TEST
FOR EACH ROW
DELARE
NUM VARCHAR2;
BEGIN
IF :NEW.YEAR||:NEW.MONTH||:NEW.DAY<TO_CHAR(SYSDATE,'YYYYMMDD') THEN
update employment_test set work_style=:new.id_class
where emp_no=:new.emp_no
and to_char(what_date,'yyyymmdd')=:new.year||:new.month||:new.day;
END IF;
END;
/
beckhambobo(beckham)的写法才是合法的。