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
- 7905 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
what are the t string functions available in tsql? : Transact sql
Differentiate between syntax and runtime errors.
What is triggering circuit?
What is sql*loader and what is it used for? : aql loader
How to change sql*plus system settings?
Can a table contain multiple primary key’s?
what is the difference difference between procedure and packages
What is clause in sql?
Does sql use python?
Which is better join or inner query?
Does varchar need length?
How run sql*plus commands that are stored in a local file?
What is rename command in sql?
Can we rollback delete command?
What is dense_rank in sql?
