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;