Stored Procedures

Stored Procedures

1. What Is a Stored Procedure? (beginner)

Stored procedure = SQL program saved INSIDE DB (named, params, logic!). Called by name from Java (fast: no SQL travel! secure: no injection! consistent: one logic for all apps!).

DELIMITER //
CREATE PROCEDURE getTop(IN n INT)
BEGIN
  SELECT id, name FROM student ORDER BY marks DESC LIMIT n;
END //
DELIMITER ;
-- call: CALL getTop(3);

4. Why Procedures? (exam reasons!)

Speed (compiled + local!), security (grant EXEC, hide tables!), consistency (fix once, all apps!), less traffic (name + params vs big SQL!).

5. Exam Points

• Define + CREATE + CALL — 5 marks, frequent.
• Benefits (speed/security) — 3 marks, frequent.