Procedure with cursor-like loop (simple)

Procedure with cursor-like loop (simple)

Medium SQL Stored Procedures 17 views
Explanation Complexity

Problem Statement

Create sp_mark_low_stock(p_limit) that sets Products.low_stock=1 when qty_on_hand < p_limit.

Input Format

SQL procedure

Output Format

Procedure created

Example

Products(qty_on_hand, low_stock)
Procedure created

Constraints

No cursor needed; set-based is fine

Input / Output Format

Input Format
SQL procedure
Output Format
Procedure created
Constraints
No cursor needed; set-based is fine

Examples

Input:
Products(qty_on_hand, low_stock)
Output:
Procedure created

Example Solution (Public)

SQL 
CREATE PROCEDURE sp_mark_low_stock(IN p_limit INT) BEGIN UPDATE Products SET low_stock = 1 WHERE qty_on_hand < p_limit; END;

Official Solution Code

CREATE PROCEDURE sp_mark_low_stock(IN p_limit INT) BEGIN UPDATE Products SET low_stock = 1 WHERE qty_on_hand < p_limit; END;
Please login to submit solutions.
Editor
Output

                                        

                                    

                                    

                                        

                                                                                    
Please login to submit solutions.