create or replace procedure
proce_name (parameter_list)
is|as
local variable declaration
begin
executable statements
exception
exception_handlers
end proce_name;

Execute proce_name(parameter_list);
--或
Declare
Variable var_list;
Begin
Proce_name(var_list);
End;
--将过程执行的权限授予其他用户：
Grant execute on proce_name to scott;
Grant execute on proce_name to public;
--删除存储过程：
Drop procedure proce_name;

Create or replace function
Fun_name (parameter_list)
Return datatype is|as
Local declarations
Begin
Executable statements;
Return result;
Exception
Exce_handlers;
End;

Select fun_name(parameter_list) from dual;