SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Count how many rows have been updated in a BULK update statement

259178Nov 8 2006 — edited Nov 21 2006

Dear all
I have a PL/SQL FORALL statement that I use to bulk update a column in a table. The statement is like this

FORALL x IN 1..<array>.counter
UPDATE mytable
SET mycolumn = 'Y'
WHERE join_col1 = <array>.<column>(x);

mycounter := mycounter + SQL%ROWCOUNT;

The problem here is that SQL%ROWCOUNT counts the iterations within the FORALL loop and not how many rows are finally updated due to the join condition..
Any ideas ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 19 2006

Added on Nov 8 2006

12 comments

2,497 views