What are the Benefits of Stored Procedure?

Benefits of Stored Procedure are as follows:

1. You can execute the set of statements in the sequence.

2. It helps you in encapsulation as only input and out is exposed to the or users.

3. Security: Help in increasing the security of the database, as it reduces the direct access to the tables

4. We can Select update delete truncate the table in the procedure.

5. Exception Error handling can be done for any server related data-related issues

6. Transactions are supported in a stored procedure to get the integrity in data

7. The nested procedure is allowed. i.e. procedure can be executed inside a procedure.