Oracle SQL, PLSQL, APEX How To's by Dr. S. Raghunathan - HTML preview

create or replace procedure "CHANGE_POSITION"

-- Two temporary I field variables are declared as al, a2

-- IN, OUT, IN OUT will be used for declaring whether to

--- receive input from system or to store or to update followed

--- with data type. Note precision will not be given at

the

--- time of declaration. (al IN NUMBER,

a2 IN NUMBER)

is

--- Any procedure should start with begin and must end with end

--- notation. begin

declare

first_number number;

second_number number;

--- another procedure also can be created within the declaration

--- section.

procedure swaps ( num_one IN OUT NUMBER, num_two IN OUT Number)

is

temp_num number;

begin

temp_num .- num_one; num_one .- num_two; num_two .- temp_num;