Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

count the row before a delete

francy77Feb 2 2021

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

This post has been answered by Alex Nuijten on Feb 2 2021
Jump to Answer

Comments

Post Details

Added on Feb 2 2021
2 comments
770 views