oracle数据库sql语句之创建和使用包的讲解,oraclesql
--创建包
create or replace package pkg_emp
as
name emp.ename%type;
procedure pro_emp(id emp.deptno%type, num out number);
function fun_deptno(p_empno emp.empno%type, p_sal out number) return emp.ename%type;
end;
/
--创建包主体
create or replace package body pkg_emp
as
procedure pro_emp(id emp.deptno%type, num out number)
as
begin
select count(*) into num from emp where deptno=id;
end;
function fun_deptno(p_empno emp.empno%type, p_sal out number) return emp.ename%type
as
begin
select ename,sal into name,p_sal from emp where empno=p_empno;
return name;
end;
end;
/
--调用包中成员
declare
num number;
sal number;
eName emp.ename%type;
begin
pkg_emp.pro_emp(10, num);
eName:=pkg_emp.fun_deptno(7902, sal);
end;
/
本站文章为和通数据库网友分享或者投稿,欢迎任何形式的转载,但请务必注明出处.
同时文章内容如有侵犯了您的权益,请联系QQ:970679559,我们会在尽快处理。