While inserting/updating million of records into a database table, how do I came to know how many records has been inserted or updated successfully so far?
Answer Posted / hairreddy
by using cursor attribute cursorname%rowcount we can find how many records fetched
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is the difference between blob and text? : Sql dba
How exception is different from error?
What types of commands can be executed in sql*plus?
What is a record in a database?
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
Can triggers stop a dml statement from executing on a table?
What is a database trigger?
What are the advantages of normalization?
How do you know if a relationship is 2nf?
How do sql databases work?
Write a query to find the names of users that begin with "um" in sql?
How can we make an if statement within a select statement?
What is difference between rank () row_number () and dense_rank () in sql?
How do I create an index in word?
What are the usages of sql?