Create or replace procedure delete_rec_cnt is begin delete from MY

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 / mathivanan

2 Answers
7789 Views
I also Faced
E-Mail Answers

Answer Posted / 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 View All Answers

Please Help Members By Posting Answers For Below Questions

What is difference between inner join and self join?

1079

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

994

How do I remove all records from a table?

1067

Can we join two tables without common column?

999

Can we debug stored procedure?

1018

Which is better varchar or nvarchar?

990

Do foreign keys improve performance?

1018

List the various privileges that a user can grant to another user?

1036

Is pl sql better than sql?

1019

What are stuff and replace function?

1073

How do I view a sql trace file?

1019

Explain table and field in sql?

1060

how to include character strings in sql statements? : Sql dba

1059

Is sql a oracle?

970

How do you run a query?

989