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
- 7653 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 sql lookup?
Can we create view in stored procedure?
what are myisam tables? : Sql dba
What is pl sql in oracle?
List and explain the different types of join clauses supported in ansi-standard sql?
How is data stored on a disk?
What is varchar used for?
What type of database is sql?
is it possible to pass an object or table to a procedure as an argument?
What is data modelling in sql?
Is full outer join same as cross join?
Why is there a need for sqlcode and sqlerrm variables?
How to handle bulk data?
How can you load microsoft excel data into oracle? : aql loader
What is duration in sql profiler trace?
