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
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;
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started