Oracle - Procedures
A Procedure is a subprogram unit that consists of a group of PL/SQL statements. Each procedure in Oracle has its own unique name by which it can be referred. This subprogram unit is stored as a database object.
A procedure is a group of PL/SQL statements that can be called by name. The call specification (sometimes called call spec) specifies a java method or a third-generation language routine so that it can be called from SQL and PL/SQL.
CREATE [OR REPLACE] PROCEDURE procedure_name [ (parameter [,parameter]) ] IS [declaration_section] BEGIN executable_section [EXCEPTION exception_section] END [procedure_name];
Following are the three types of procedures that must be defined to create a procedure.
In this example, we are going to insert record in the "user" table. So you need to create user table first.
create table user(id number(10) primary key,name varchar2(100));
Now write the procedure code to insert record in user table.
create or replace procedure "INSERTUSER" (id IN NUMBER, name IN VARCHAR2) is begin insert into user values(id,name); end; /
Let's see the code to call above created procedure.
BEGIN insertuser(101,'Rahul'); dbms_output.put_line('record inserted successfully'); END; /
Now, see the "USER" table, you will see one record is inserted.
DROP PROCEDURE procedure_name;
DROP PROCEDURE pro1;
What Is Oracle
posted on 2019-11-29 01:11:21 - ORACLE Tutorials
ORACLE - Trigger
posted on 2019-11-28 22:14:22 - ORACLE Tutorials
ORACLE - Cursor
posted on 2019-11-28 22:13:54 - ORACLE Tutorials
MySQL - Triggers
posted on 2019-11-29 21:44:07 - mysql Tutorials
MySQL - Grant_ Revoke Privilege
posted on 2019-11-26 23:15:04 - mysql Tutorials
MySQL Vs SQL
posted on 2019-11-25 05:02:26 - mysql Tutorials