InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
How To Retrieve The Count Of Updated Rows? |
|
Answer» After running an UPDATE STATEMENT, the database server returns a COUNT of updated rows. You can retrieve this count from a special predefined variable called SQL%ROWCOUT, as shown in the following TUTORIAL: CREATE TABLE emp_temp AS SELECT * FROM employees; BEGIN UPDATE emp_temp SET salary = salary * 1.05 WHERE salary < 5000; DBMS_OUTPUT.PUT_LINE('# of rows updated: ' || SQL%ROWCOUNT); END; / # of rows updated: 49After running an UPDATE statement, the database server returns a count of updated rows. You can retrieve this count from a special predefined variable called SQL%ROWCOUT, as shown in the following tutorial: |
|