What are the steps to create a stored procedure?

Answer:

The stored procedure is created using keyword Create Proc or Create Procedure.The procedure should be paramerized along with data types.
The required logic should be inserted in begin and end block
In order to execute the stored procedure use exec