A stored procedure is a collection of SQL statements assembled into a manageable block (also known as a Single Execution Plan) which is precompiled and stored in the database data dictionary. The stored procedure technique simplifies the database development process. Stored procedure helps in accomplishing a steady execution of logic across programming languages and platforms. A block of SQL statements, with the needed business logic, can be written, analyzed and validated in a stored Continue Reading >>