Explain the uses of stored procedure

Question

Explain the uses of stored procedure?

Answer 1

Stored procedures are frequently used for data validation and like access control mechanism. Logic applied within applications can be centralized and stored in applications. Complex functionalities and procedures which need huge amount of data processing and logic implementation access their data through procedures. Data is stored into these accessed and procedures by procedures.