Hi all,
In a store procedure, I need to delete some row, and I want to know how many rows I'm going to delete before to really delete them,
for example I can write
select count(k_id) into count from tab1 where id_s=12;
and after
delete from tab1 where id_s=12;
But I'm asking if there is a different way to accomplish this.
thanks