Friday, October 26, 2007

Differentiate between variables

create or replace package my_pkg
as
g_variable varchar2(10);
procedure p (p_variable in varchar2) is
l_variable varchar2(10);
begin
null;
end;
end;

the g_variable - can be viewed by the whole package
the p_variable - is a parameter variable
the l_variable - is the local variable

No comments: