Stored Procedures are created to perform one or more DML operations on Database.
create or REPLACE Procedure name(parameters) is variables;
BEGIN
//content list
END;
Example::
create Procedure selectAllCustomers as select * from customes Go;
