sql% rowcount

[cleberzumba]

Wanted to know if the SQL% rowcount command only returns lines processed by DML statements, does it not work for a SELECT?

Ex:

Select Count (*) From <table>

[dr_gori]

% Rowcount returns the number of rows returned from a fetch in the cursor. If you do a cursor with Select Count (*), it will return 1 as it is returning only 1 line of the cursor. (With the quantity)

Another thing that you can do is count how many records were affected by an update. Hence, we use SQL% Rowcount.
Example:

Select all

update SUA_TABELA 
  set ok='x' 
  where ok='S'; 
   
  dbms_output.put_line(sql%rowcount); 

In that case, the output will be the amount of rows that the Update did.