Procedure

A procedure is a block of PL/SQL code named and stored within the database.

Example

CREATE OR REPLACE PROCEDURE raise_sal(i_empno NUMBER, i_newsal NUMBER)
AS
BEGIN
  UPDATE emp SET sal = i_newsal WHERE empno = i_empno;
END; 

Also see

• Anonymous block
• Function
• Package
• Trigger

Glossary of Terms
A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	#