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
- 7790 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 is acid property in database? : Sql dba
what is a record in a database ? : Sql dba
What is group function in sql?
What is the difference between nvl function, ifnull function, and isnull function?
Does sql use python?
State some properties of relational databases?
what is the difference between delete and truncate commands? : Sql dba
explain mysql aggregate functions. : Sql dba
What are the benefits of pl sql?
What is hibernate and its relation to sql?
Explain the update statement in sql
How do I partition a table in sql?
What are different joins used in sql?
How do I copy a table in sql?
What is the meaning of disabling a trigger?
