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
- 7628 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 left inner join in sql?
Does pl sql work in mysql?
How does a covering index work?
how many ways we can we find the current date using mysql? : Sql dba
Why is a primary key important?
What is sql constant?
Does oracle roll back the transaction on an error?
what is a field in a database ? : Sql dba
What is assignment operator in pl sql?
What are the operators in sql?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
What are its different types of dbms?
What is composite data type in pl sql?
Which are sql * plus commands?
what are the security recommendations while using mysql? : Sql dba
