Can I read PL/SQL Triggers for Order Management on EtoBox?
PL/SQL Triggers for Order Management by Sumit Tembhare is a document available to read on EtoBox.
What is PL/SQL Triggers for Order Management about?
The document describes creating tables and inserting sample data. It then lists 4 triggers to be created: 1) a before insert trigger on Ord_dtl to increase the booked quantity in Prod_mst, 2) a before delete trigger on Ord_dtl to decrease the booked quantity in Prod_mst, 3) a before update trigger on Ord_dtl to increase/decrease the booked quantity in Prod_mst based on product code or quantity updates, and 4) a before update trigger on Ord_mst to decrease the booked quantity and stock quantity in Prod_mst i
- Author
- Sumit Tembhare
- Language
- EN