CREATE OR REPLACE PROCEDURE proc_name(p_a IN Number)作为
开始
END进程名称;/
哦,很多事情都是可能的!这里只有一个例子:
SQL> create or replace procedure proc_name(p_a in number) as
2 l_value number;
3 begin
4 select count(*) into l_value --> here's your query in the procedure
5 from emp
6 where deptno = p_a;
7
8 dbms_output.put_line('Number of employees in dept. ' || p_a || ' is '|| l_value);
9 end proc_name;
10 /
Procedure created.
它是如何工作的?
SQL> set serveroutput on
SQL> begin
2 proc_name(10);
3 end;
4 /
Number of employees in dept. 10 is 3
PL/SQL procedure successfully completed.
SQL>
如果这不是你想要的,也许你应该更好地解释这个问题。