Oracle:创建存储过程

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;