CREATE OR REPLACE TRIGGER WK.t_quote_del_q_id
AFTER DELETE
ON quote
FOR EACH ROW
BEGIN
DELETE quoted_price
WHERE qp_id = :OLD.q_id;
END;
/CREATE OR REPLACE TRIGGER WK.t_quote_q_id
AFTER UPDATE
ON quote
FOR EACH ROW
BEGIN
IF :NEW.q_id <> :OLD.q_id
THEN
UPDATE quoted_price
SET qp_id = :NEW.q_id
WHERE qp_id = :OLD.q_id;
END IF;
END;
/
AFTER DELETE
ON quote
FOR EACH ROW
BEGIN
DELETE quoted_price
WHERE qp_id = :OLD.q_id;
END;
/CREATE OR REPLACE TRIGGER WK.t_quote_q_id
AFTER UPDATE
ON quote
FOR EACH ROW
BEGIN
IF :NEW.q_id <> :OLD.q_id
THEN
UPDATE quoted_price
SET qp_id = :NEW.q_id
WHERE qp_id = :OLD.q_id;
END IF;
END;
/
create or replace trigger ...
after delete or update on ... for each row
begin
if deleting then
...;
elsif updating then
...;
end if;
end;