--创建包
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;
/
如对本文有疑问, 点击进行留言回复!!
Oracle 基本概念 Dadabase,schema,user,table...
dbeaver连接Oracle中文乱码的解决方案--druid
Oracle常用语句(时间格式、去重、去特殊符号、查询表空间等)
Navicate 如何导出数据库中的存储过程、事件、视图等?
网友评论