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
7811 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 sql profiler in oracle?

1095

What are inner and outer joins examples of both?

963

What packages are available to pl/sql developers?

1059

What is a .db file?

987

What is PL/SQL Records?

1190

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

1048

What is java sql driver?

1125

What is an inconsistent dependency?

1047

How do you update a table in sql?

990

What does inner join mean?

1169

what is a database? : Sql dba

1173

What is interval partition?

1056

What is break?

1198

What if we write return in procedure?

1429

what is msql? : Sql dba

989