oracle中游标cursor的使用和定时器job用法(网上收集加整理的).docVIP

游标的用法（游标是一种类似与迭代器的东西） 给实际工资加100： create or replace procedure pro_salryadd is begin declare v_salry neu_study.fact_salry%type; v_id neu_study.row_id%type; cursor c_salry is select fact_salry,row_id from neu_study; begin open c_salry; loop fetch c_salry into v_salry,v_id; exit when c_salry%notfound; update neu_study set fact_salry = fact_salry + 100 where row_id = v_id; end loop; close c_salry; end; commit; end pro_s