hello, i need your help how to display updated rows from this update procedure using% ROWCOUNT
The code is this:
CREATE OR REPLACE procedure updatetab (dep_id in varchar)
as
begin
update departments
set
department_name='A'
where department_id=dep_id;
end updatetab;
Thanks