Hi,
Assuming that , I issue a DML statement like this,

update table_name
set col1 = 'Y'
where col1 = col2.

How do I how, How many rows for col1 got updated with 'Y'.

Badrinath