Home/ Questions/Q 3853
Next
In Process
Question
Beter
  • 0
Explorer
Asked: 2016-07-31T21:06:40+03:00 In:

How to know number of rows updated by UPDATE statement ?

  • 0

I have a PL/SQL procedure to update a number of rows in a table. is there is there any way to know the number of rows updated by update statement executed inside my procedure?

oraclepl/sqlrowsupdate statement
Share

    Related Questions

    1 Answer

    1. Master Oracle ACE Pro ♠ | Oracle Senior ERP Technical Consultant

      SQL%ROWCOUNT :  return the number of rows fetched/processed by the last DML executed. If the DML fails after fetching 1 row, due to any reason, SQL%ROWCOUNT will return only 1, the number of rows fetched/processed so far
      basically you can use :

      BEGIN
        UPDATE xx_test_tab
        SET    test_col = 777777
        WHERE  col2 LIKE '2%';

        DBMS_OUTPUT.PUT_LINE(TO_Char(SQL%ROWCOUNT)||' rows affected.');
      END;

      hope this help 🙂

      • 0

    Leave an answer

    You must login to add an answer.

    Need An Account,