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='')
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
What are the possible values that can be stored in a boolean data field?
How do I filter in sql profiler?
How many types of cursors are available in pl/sql?
What is embedded sql what are its advantages?
How to run sql functions in pl/sql?
Which is better cte or subquery?
What is mutating error?
Can we call procedure in select statement?
Are subqueries faster than joins?
What is primary key in db?
what is sp_pkeys? : Transact sql
Define a temp table?
How do you declare a variable in pl sql?
What is a data definition language?
What is constant in pl sql?