存储过程与存储函数

存储过程

--存储过程--
create or replace procedure procedure_name
(parameter_name in/out parameter_type,parameter_name in/out parameter_type)
as
begin
  do something;
end;

存储函数

create or replace function function_name
(parameter_name in/out parameter_type,parameter_name in/out parameter_type)
return return_type 
as 
ret varchar(50);--declaration variable-- 
begin 
　　do_sonething; 
　　return ret; 
end;