Oracle - Retrieve the Count of Updated Rows in Oracle

Retrieve the Count of Updated Rows in Oracle

Q

How To Retrieve the Count of Updated Rows in Oracle?

✍: FYIcenter.com

A

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

⇒Working with Database Objects in Oracle PL/SQL

⇒⇒Oracle Database Tutorials

2018-09-13, 434👍, 0💬

Error: Exact Fetch Returns More Rows in Oracle
Can You Assign Multiple Query Result Rows To a Variable in Oracle? You can use "SELECT ... INTO variable" to assign query results to variables. But what happens if the SELECT statements return multiple rows? The answer is that you will get a run time error. The following tutorial exercise shows this... 2018-09-24, 549👍, 0💬

Implicit Cursor in Oracle
What Is the Implicit Cursor in Oracle? The implicit cursor is the cursor automatically defined by PL/SQL for you. Whenever a SQL statement is executed, this cursor will be assigned to represent the execution of this statement. This implicit cursor is called SQL. It has many attributes representing s... 2018-09-13, 527👍, 0💬

Retrieve the Count of Updated Rows in Oracle
How To Retrieve the Count of Updated Rows in Oracle? 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 e... 2018-09-13, 435👍, 0💬

Assign Data from a Deleted Row to Variables in Oracle
How To Assign Data of the Deleted Row to Variables in Oracle? If a DELETE statement is deleting a single row, you can assign column values of the deleted row to variables by using the RETURNING clause, which an extension of DELETE statements for PL/SQL. The tutorial script shows you how to do this: ... 2018-09-13, 401👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.