In PL/SQL:
Brewbeans has a BB_PRODUCT_REQUEST table where requests torefill stock levels are inserted automatically via a trigger. Afterthe stock level falls below the reorder level, this trigger firesand enters a request in the table. This procedure works great;however, when store clerks record that the product request has beenfilled by updating the table’s DTRECD and COST columns, they wantthe stock level in the product table to be updated. Create atrigger named BB_REQFILL_TRG to handle this task, using thefollowing steps as a guideline:
1. In SQL Developer, run the following INSERT statement tocreate a product request you can use in this exercise:
INSERT INTO
OR
OR