Interested to Buy Any Domain ? << Click Here >> for more details...
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='')
- 2 Answers
- 7629 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
What is the file extension for sql database?
What is sqlerrm?
What is range partitioning?
Why select is used in sql?
What is vector point function?
How do I use google cloud in sql?
What does the sign mean in sql?
Why is pl sql needed?
How can the performance of a trigger be improved?
What is a dynamic query?
What is restrict in sql?
Explain dml and ddl?
what are the t string functions available in tsql? : Transact sql
How does sql profiler work?
What is clustered index sql?
