一,Oracle中的过程,函数
对于oracle中的过程和函数,个人觉得可以化为一类,因为它们在写法上并没有什么的不同。公式无非就是
create or replace Package_name(paramater1 in type,paramater2 in type,out_message out type)
is
locate_paramater1 type;
locate_paramater2 type;
begin
begin
select sth into locate_paramater1 from table_name where 。。。。
exception
when no_data_found then
locate_paramater1:=' ';
out_message:='Some Information to user to look';
end
begin
select sth into locate_paramater2 from table_name where 。。。。
exception
when no_data_found then
locate_paramater2:=' ';
out_message:='Some Information to user to look';
end
end
总而言之,言而总之:包声明,私有数据神马的在紧跟is之后。接着就是一串的begin......exception....end;
函数
create or replace function_name(paramater1 in type,paramater2 in type)
return return_type;
is
locate_paramater1 type;
locate_paramater2 type;
out_message return_type;
begin
begin
select sth into locate_paramater1 from table_name where 。。。。
exception
when no_data_found then
locate_paramater1:=' ';
out_message:='Some Information to user to look';
return out_message;
when others then
out_message:='Error';
return out_message;
end
begin
select sth into locate_paramater2 from table_name where 。。。。
exception
when no_data_found then
locate_paramater2:=' ';
out_message:='Some Information to user to look';
return out_message;
end