更新前先算一下!呵呵,或者 declare i integer; TYPE t_balance IS TABLE OF number; v_Recs_bal t_balance; begin update card_auth d set auth_or_reverse='F' where auth_or_reverse='A' returning card_balance bulk collect into v_Recs_bal;
dbms_output.put_line(v_Recs_bal.count); end;
使用 内置游标SQL,例如: begin SET SERVEROUTPUT ON; delete from table_XXX;
declare
i integer;
TYPE t_balance IS TABLE OF number;
v_Recs_bal t_balance;
begin
update card_auth d set auth_or_reverse='F' where auth_or_reverse='A'
returning card_balance bulk collect into v_Recs_bal;
dbms_output.put_line(v_Recs_bal.count);
end;
begin
SET SERVEROUTPUT ON;
delete from table_XXX;
dbms_output.put_line(SQL%ROWCOUNT);
end;
/