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

PLEASE NOTE: This is an HTML preview only and some elements such as links or page numbers may be incorrect.
Download the book in PDF, ePub, Kindle for a complete version.

 

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;