The PL/SQL stored procedure or simply a procedure is a PL/SQL block which performs one or more specific tasks. It is just like procedures in other programming languages.
The procedure contains a header and a body.
How to pass parameters in procedure:
When you want to create a procedure or function, you have to define parameters .There is three ways to pass parameters in procedure:
A procedure may or may not return any value.
PL/SQL Create Procedure
Syntax for creating procedure:
Create procedure example
In this example, we are going to insert record in user table. So you need to create user table first.
Now write the procedure code to insert record in user table.
PL/SQL program to call procedure
Let's see the code to call above created procedure.
Now, see the "USER" table, you will see one record is inserted.
PL/SQL Drop Procedure
Syntax for drop procedure
Example of drop procedure