关系数据库常用对象

Oracle自定义函数语法例程

create or replace function f_sum(p1 in int,p2 in int)
return int
is
begin
return p1+p2;
end;

Oracle自定义存储过程语法

set serveroutput on

create or replace procedure p_sum(p1 in int,p2 in int)
as
begin
dbms_output.Put_line(to_char(p1 + p2));
end;