Dev Corner

Software Developer’s Notepad

Implicit Cursor – Get the Number of Rows Affected by SQL Query in Oracle PL/SQL

baobab under Oracle Tips

You can use the SQL implicit cursor to retrieve the number of rows, affected by SQL query: SQL%ROWCOUNT.

BEGIN
  UPDATE employee
     SET salary = salary * 1.1
   WHERE salary_range = 'middle';
  dbms_output.put_line('Number of affrected rows: ' || SQL%ROWCOUNT);
END;

« Declare Variables, Constants and Types in Oracle PL/SQL

Find Invalid Objects in Oracle Database »

Add A Comment

You must be logged in to post a comment.

Subscribe to Dev Corner