Oracle存储过程

最基本的存储命令

create or replace procedure pfliu()begin

tselect * from user

end；

调用存储过程

call pfliu()

删除储存过程

drop procedure if exists pfliu()

带参数的存储过程

支持:in out inout

存储过程的代码位于begin和end之间，用来检索值，然后保存到相应的变量中( into关键字)decimal(8, 2)十进制

create or replace procedure pfliu(out minScore decimal (8, 2)，

out maxScore decimal(8, 2)，out avgScore decimal(8, 2)

begin

select min(score) into minScore from userselect max (score) into maxScore from user;select avg(score) into avgScore from user,end;

一-调用存储过程的时候必须指定三个变量名(用@开call pfliu (@minScore, @maxScore, @avgScore)

select @minScore, @maxScore, @avgScore;

使用in来输入用户的id

create or replace procedure pfliu(

in userId int,

out userName varchar (32) )

begin

select name from usern where id=userId into userName

end ;

call procedure pfliu(1, @userName)select @userName