oracle中sql屏蔽触发器,sql – Oracle：在触发器中使用子查询

这个触发器会这样做：

CREATE OR REPLACE TRIGGER trigger_w_subquery

AFTER UPDATE OR INSERT ON project_archiving

FOR EACH ROW WHEN (old.archiving_status <> new.archiving_status

AND new.archiving_status = 1

)

DECLARE

l_offer projects.offer%TYPE;

BEGIN

SELECT offer INTO l_offer

FROM projects

WHERE projnum = :new.projnum;

IF l_offer IS NULL THEN

INSERT INTO offer_log (offer, status, date)

VALUES (null, 9, sysdate);

END IF;

END;

我假设从项目中选择总是会找到一行;如果不是,它将引发您可能需要处理的NO_DATA_FOUND异常.