Collections:
Retrieve the Count of Updated Rows in Oracle
How To Retrieve the Count of Updated Rows in Oracle?
✍: FYIcenter.com
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: 49
⇐ Invoke Built-in Functions in PL/SQL in Oracle
2018-09-13, 1746🔥, 0💬
Popular Posts:
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...
How To Convert Binary Strings into Integers in SQL Server Transact-SQL? Binary strings and integers ...
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...