I had task to update 1 lakhs records in normal SQL statement.
For example: UPDATE SAL_DETAILS SET SAL = salary *10 WHERE department in ('IT'); --- It contains more than 1 lakhs records.
When i execute this statement in my active session, it takes 10 minutes usually. Here my question is:
1) Is it possible to get updated records count details in 5th minute before update statement completes?
2) Is it possible to get updated records details in 5th minute before update statement completes?
FYI,
1) I want to check this during UPDATE statement execution before completes, expecting answer in SQL methods.
2) Usually, SQL%ROWCOUNT and RETURNING INTO will give the desired result after the completion i guess. Please support on this.
Thanks in advance.