pl/sql within the oracle environment utilize the outdoor clubs and product datab

Question

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;

Explanation / Answer

Select update product

set quantity_in_stock=5

where product_id=10012;

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.