oracle update根据条件,怎样让oracle语句实现insert和update根据条件casewhe

CREATE OR REPLACE TRIGGER "BASEINFO"

AFTER insert OR update

ON BASEINFO

FOR EACH ROW

DECLARE

nextseq NUMBER;

BEGIN

select BASEINFO.nextval into nextseq from dual;

CASE

WHEN inserting THEN

INSERT INTO BASEINFO ( ID, STATUS, OP, EX, DATE, S_EXT_TIMESTAMP )

VALUES (nextseq, 'NEW', '0', -1, sysdate, :new.S_EXT_TIMESTAMP);

WHEN updating THEN

INSERT INTO BASEINFO ( ID, STATUS, OP, EX, DATE, S_EXT_TIMESTAMP )

VALUES (nextseq, 'NEW', '1', -1, sysdate, :new.S_EXT_TIMESTAMP);

END;