Which are the procedures of database?

Procedures in a database are stored code segments, which can be executed. This is a good way of holding any business logic in a single place. A procedure could be very simple and return the value of the square of two number, or be very complicated, and perform a lot of data validation before inserting data into a table or updating a table for example.