oracle存储过程个人学习小结

oracle存储过程个人学习总结

常用分支循环：

create or replace procedure getcatalog(v_id in number,cur_catalog out sys_refcursor)asbegin  open cur_catalog for select * from catalog where pid = v_id;end;

?

?