Create a procedure to delete certain records from a table and display the tota

Create a procedure to delete certain records from a table
and display the total number of records deleted in this
process. (Condition for deletion can be of ur choice, for
instance delete all records where eid='')

Question Posted / v karthik.

2 Answers
6756 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Create a procedure to delete certain records from a table and display the total number of records ..

Answer / manas

create or replace procedure proc_name(noofcount out number ) is
Begin
Delete from tes_tabt;
noofcount := sql%rowcount;
End

Is This Answer Correct ?

7 Yes

1 No

Create a procedure to delete certain records from a table and display the total number of records ..

Answer / mathivanan

Create or replace procedure delete_rec_cnt is
begin
delete from MY_TABLE;
dbms_output.put_line(sql%rowcount);
end;

Is This Answer Correct ?

1 Yes

0 No

Post New Answer