pl/sql within the oracle environment

utilize the outdoor clubs and product database to create a trigger "product_reorder_au" that is associated with an update operation on the product table. the trigger checks to see whether during the update of the quantity_in_stock attribute, if its value gets lower than the reorder_point attribute value for a product. when this situation occurs, the trigger automatically inserts a new purchase order in the purchase_order table. the new purchase order will use the existing supplier_no attribute value for the product in the product tabe, and the quantity attribute value will be the same as the reoder _qty value for the product in the product table. save the trigger source as a script file.

For example, the following update statement will generate a new purchase order. update product set quantity_in_stock = 5 where product_id = 10012;