创建包
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;