create or replace procedure test_add(id varchar,name varchar,time varchar,age varchar,sex varchar) is

begin

insert into table(id,name,time,varchar,age,sex);

commit;

end;

执行语句如下：

set serveroutput on;

call test_add('','zhangsan','2019-06-21','','男')；

create or replace procedure test_update(id varchar,mc varchar)is

begin

update ly_tb set  ly_mc where ly_id = id;

commit;

end;

执行语句如下：

set serveroutput on;

call test_update('','lisi');

end;

create or replace procedure test_select(sex varchar)is

begin

countNum number();

maxId      number();

begin

select  count(*),max(id) into countNum,maxId from ly_tb where ly_nb=sex;

dbms_output.putline(countNum);

dbms_output.put_line(maxId);

end;