Explain the stored procedure in the Teradata

Question

Explain the stored procedure in the Teradata?

Answer 1

A stored procedure is a group of SQL statements which form a logical unit and perform a particular task. These procedures are used to encapsulate a set of queries or operations to execute on a database server. For illustration, operations on a worker database (as hire, promote, fire and lookup) could be coded as stored procedures executed through application code. It can be compiled and executed along with different results and parameters, and they may have some combination of input and output and input/output parameters.