How can I display the number of records updated after an Oracle UPDATE statement.?

Question

In a Oracle procedure, I have an update statement like:

UPDATE employee
SET salary = 1000
WHERE dept_no = 10;

I want it to set a variable (that I can use later) or pop up a message telling me how many records were actually updated in that statement.

How can I do that?

I am using Oracle Forms. This is part of a PL/SQL package in Forms.

Answer 1

Set your variable to SQL%ROWCOUNT or pop up your message displaying the SQL%ROWCOUNT.

Answer 2

Depends on what you're using to execute the SQL. In Java JDBC, for example, any update statement returns the number of rows impacted.