CREATE OR REPLACE TRIGGER New_Price BEFORE INSERT OR UPDATE of Acquisi

1
2
3
4
5
6
7
CREATE OR REPLACE TRIGGER New_Price
BEFORE INSERT OR UPDATE of Acquisitionprice ON TRANSACTION
FOR EACH ROW
BEGIN
:new.AskingPrice := :new.AcquisitionPrice * 2;
END;
/