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
- 7812 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 types of optimization?
Which version of sql do I have?
how to create a new view in mysql? : Sql dba
How do you identify a primary key?
write an sql query to find names of employee start with 'a'? : Sql dba
Explain locks? : Transact sql
what is a join? : Sql dba
write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba
What is trigger and types?
Is like operator in sql case sensitive?
Explain some predefined exceptions.
What is a unique constraint?
What is the largest value that can be stored in a byte data field?
what does it mean to have quoted_identifier on? : Sql dba
What is the difference between truncate and drop statements?
