Summary: The Oracle databases allow the encapsulation of a PL/SQL inside a procedure, which is a common subprogram that can be used to reuse code. This video discuss about the following advantages of procedures in Oracle: modularity, reusability, extensibility, maintainability, data security, integrity, improved performance and code clarity. Next, the video shows how to create and execure a simple procedure without any parameters. The types of parameters (IN, OUT and IN OUT) as discussed next followed para one example for example for each type of parameter. The video also present how to work with default valued for parameters and how to remove a procedure using the commando DROP PROCEDURE.