大阳阳

摘要： --创建简单过程create or replace procedure pro_hello(u_name in varchar2) asbegin dbms_output.put_line(u_name);end;--调用过程begin pro_hello('dddd');end;select * from emp;--使用游标的过程create or replace procedure pro_empbySal(e_sal in number)as cursor cur_emp is select * from emp where sal>e_sal;begin for 阅读全文