CHECKPRODUCT

<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   CHECKPRODUCT

Simple Trigger of AFTER "update ON Product"

Name	Types	Value
N	Variable
No Reference found for \"N\"

CREATE OR REPLACE TRIGGER CheckProduct
AFTER update ON Product
FOR EACH ROW
DECLARE
    n INTEGER;
BEGIN
    Products.CheckPrice(:new.UNIT_PRICE);
END

Name	Types	Description
<DEFAULT SCHEMA>.PRODUCTS	Package	Package, Interface
<DEFAULT SCHEMA>.PRODUCT	Table	Table
<DEFAULT SCHEMA>.PRODUCTS.CheckPrice	Function	Function interface CheckPrice(price NUMBER) return BOOLEAN, Package PRODUCTS
<DEFAULT SCHEMA>.PRODUCT.UNIT_PRICE	Column	Column
INTEGER	PL/SQL System type	PL/SQL System Object

Name	Types	Description
<DEFAULT SCHEMA>.EMPLOYEE_DELETING.Update	Update Statement	UPDATE PRODUCT SET MANAGER_ID = managerId WHERE c.ID = Id
<DEFAULT SCHEMA>.PRODUCTS.UpdateProductPrice.Update	Update Statement	UPDATE PRODUCT SET unit_price=price WHERE id = productId