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='')
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
Why is sql*loader direct path so fast?
How global cursor can be declare with dynamic trigger ?
What are all different types of collation sensitivity?
What is compute?
What are the ways on commenting in a pl/sql code?
What is the difference between subquery and correlated query?
What is trigger point?
How can we optimize a sql query?
How do I truncate a sql log file?
Is postgresql a server?
How do sql databases work?
How many row comparison operators are used while working with a subquery?
What is using in sql?
what is text? : Sql dba
explain normalization concept? : Sql dba