Create a PL/SQL Trigger to display the message "Re-Order Level reached for the item-item name", whenever an item quantity reaches 10 and below while updating for inserting an item.
Please check the attachment for additional information.
You can try this and let me know.
Create or replace trigger threshold
On Stock
Before insert or update
For each row
Is
V_qty number;
V_desc varchar2(30);
Begin
Select quantity, description into v_qty, v_desc
From stock
Where itemid = :new.itemid;
If v_qty < 10 then
Dbms_output.put_line(' Re-order level reached to the item: '||v_desc);
End;
create or replace trigger stock_alert
after insert or update of quantity on stock
for each row
begin
IF :new.QUANTITY <= 10 THEN
DBMS_OUTPUT.PUT_LINE ('Re-order Level reached for the item-'|| :old.description );
END IF;
END;
/
Try this one
Leave a reply
Latest Post: Query Optimization: A Comprehensive Guide for Stored Procedures Our newest member: anjalirrb Recent Posts Unread Posts
