oracle - Number of rows affected by an UPDATE in PL/SQL - Stack Overflow

oracle - Number of rows affected by an UPDATE in PL/SQL - Stack Overflow

瀏覽:714
日期:2025-11-14
You use the sql%rowcount variable. You need to call it straight after the statement which you need to find the affected row count for. For example: declare i number; begin update employees set status = 'fired' where name like '%Bloggs'; i := sql%rowcount;...看更多