What is a stored procedure? -> A set of of SQL statements stored and executed on the database server. Benefits of stored procedures : 1- Reduction in network traffic 2- Improvement in performance 3- Reuse of code 4- Increase in security How to work with stored procedures: Call from: a) Dynamic SQL statements b) External applications For example: CALL UPDATE_SAL("E1001", 1)