Number of rows affected by an UPDATE in PL SQL

Question

There is a PL/SQL function  which is running on Oracle 10g) in which I have to update some rows. Can I know how to find out how many rows were affected by the UPDATE? While I was executing the query manually it tells me how many rows were affected, But how do I get the number in PL/SQL?

Answer 1

You can try using the following query:

SELECT COUNT(DISTINCT programme_name) AS Count,
  programme_type AS [Type] 
FROM production 
WHERE push_number=@push_number 
GROUP BY programme_type

DISTINCT COUNT(*) will return a unique row for each unique count. 

 COUNT(DISTINCT <expression>): gives you expression for each row in a group and returns the number of unique, non-null values.