package and package body

 创建包

     create or replace package package_test
 as
  function test(a varchar2)
  return varchar2;
end package_test;
 

 

 

创建包体

 

create or replace package body package_test is
  function test(a varchar2)
  return varchar2
  is
  b varchar2(20);
  begin
  b:='xx';
  dbms_output.put_line(b);
  return b;
  end;

end package_test;