I would like to avoid another SELECT statement to capture the count and find an easy way to track the updates.
If this is the only option, then I may have not much of a choice but use it. This is upposed to be production code and not just a sample SQL-PLUS code.
bartha
Hi,
I need to capture the number of rows that were updated using UPDATE command.
For Example:
UPDATE t1
SET Col_1 = 'Col_1', Col_2 = 'Col_2'
WHERE Col_3 = 'TEK'
AND Col_4 = 'TIP'
Once this is executed, I need to be able to capture the number of rows that was updated. What might be the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.