Create a procedure

• We create a procedure with the CREATE OR REPLACE PROCEDURE.
• When a procedure is created, it is first compiled and then stored in the database in compiled form.
• A procedure call is a PL/SQL statement by itself, it is not called as part of an expression.
• A procedure is PL/SQL block, with a declarative section, an executable section, and an exception-handling section. Only the executable section is required.
• The create statement is DDL operation, so an implicit commit is done both before and after the procedure is created.
• Either IS or AS keyword can be used.
• There is no declaring keyword in a procedure or function declaration.