声明:
初始化:
统计:
v_rijie_count_shiji number(12);
v_jfjl_count_shiji number(12);
v_fyjl_count_shiji number(12);
初始化:
v_rijie_count_shiji := 0;
v_jfjl_count_shiji := 0;
v_fyjl_count_shiji := 0;
统计:
DELETE FROM feiyong_jilu_ys ys WHERE ys.jfjl_id = rec_jiaofei_jilu.jfjl_id;
v_fyjl_count_shiji := v_fyjl_count_shiji + sql%rowcount;
说明:sql%rowcount表示成功 DELETE 的记录数目
UPDATE jiaofei_jilu SET Jfjl_jiezhuan_bz '1'
WHERE jfjl_id = rec_jiaofei_jilu.jfjl_id;
v_jfjl_count_shiji := v_jfjl_count_shiji + sql%rowcount;
说明:sql%rowcount表示成功 UPDATE 的记录数目