oracle声明package里的函数,Oracle 存储过程procedure,函数function用法,以及package用法...

Oracle 存储过程procedure，函数function用法，以及package用法使用scott登录normal，简单的操作emp表实现存储过程，函数，包

定义存储过程：

create or replace procedure get_user_name(userid in emp.empno%type)

is

xx emp.ename%type;

begin

select ename into xx from emp where empno=userid;

dbms_output.put_line(xx);

end;

定义函数：

create or replace function get_user_sal(userid in emp.empno%type) return number is

salary emp.sal%type;

begin

select sal into salary from emp where empno=userid;

return salary;

exception

when NO_data_founD then

dbms_output.put_line('NOT FOUND!');

end get_user_sal;

定义包头：

create or replace package ex

is

procedure get_user_name(userid in emp.empno%type) ;

function get_user_sal(userid in emp.empno%type) return number;

end ex;

定义包体：

create or replace package body ex

is

procedure get_user_name(userid in emp.empno%type)

is

xx emp.ename%type;

begin

select ename into xx from emp where empno=userid;

dbms_output.put_line(xx);

end;

function get_user_sal(userid in emp.empno%type) return number