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, 635👍, 0💬

Invoke Built-in Functions in PL/SQL in Oracle
How To Invoke Built-in Functions in PL/SQL in Oracle? Of course, you can invoke SQL functions in SQL statements. But many SQL functions can also be executed in regular PL/SQL statements, as shown in the following sample script: DECLARE now DATE; id NUMBER; str VARCHAR2(40); BEGIN now := SYSDATE; DBM... 2018-09-13, 787👍, 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, 738👍, 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, 636👍, 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, 580👍, 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.