编写一个数据库触发器,当任何时候某个销售单从"deliverydetail"中删除时,该触发器将从"deliverymaster"表中删除该销售单的所有信息。
deliverydetail(PurchaseID,ProductID,PurchaseQuantity,PurchaseUnitPrice,PurchaseAmount);
deliverymaster(PurchaseID,PurchaseDate,SupplierID,PurchaseProperty,SubTotal)
我这样子写就出错了:创建触发器时出现 PLS-00049: 错误的赋值变量:"old.PurchaseID"
create or replace trigger del_DeliveryDetail
before deleteon DeliveryDetail for each row
begin
delete from DeliveryMaster where DeliveryMaster.PurchaseID= :old.PurchaseID;
end del_DeliveryDetail;
|