1.无参存储过程

create or replace procedure test_proc

as

v_total number(10);

begin

  select count(*) into v_total from F_RELATION;

  DBMS_OUTPUT.put_line('总人数：'||v_total);

end;

begin

  test_proc;

end;

 

2.有参存储过程

create or replace procedure test_proc(

v_name in VARCHAR2,

anum in varchar2 ,

cid in integer default 100

)

as

v_total number(10);

begin

  select count(*) into v_total from F_RELATION;

  DBMS_OUTPUT.put_line('总人数：'||v_total||',id='||v_name||',anum='||anum||',cid='||cid);

end;

begin

  test_proc('101','this is anum');

end;