天堂有路慢慢走，俯首甘为博之牛

存储过程，弄了一个多小时，哎终于解决，原来变量写错，郁闷，不够细心啊create or replace procedure sp_student(stuname in varchar2) isv_sal student.sal%type;beginselect sal into v_sal from student where name = stuname;if v_sa...

存储过程中的输入和输出create or replace procedure sp_test ascursor c_groupisselect ename from emptestwhere sal > 2000 group by job;beginfor r_group in c_grouploopupdate emptest set comm =...

java 调用存储过程 创建存储过程create or replace procedure sp_inout (i_id in int , o_name out varchar2 , o_job out varchar2)asbegin select ename,job into o_name,o_job from emp...

   //下面为游标知识 declare --定义游标type emp_cursor is ref cursor;star_cursor emp_cursor;beginopen star_cursor for select ...;loop fetch star_cursor into ...; dbms...;end ...