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
Is it possible to create startup or shutdown trigger for on-schema?
What is the difference between execution of triggers and stored procedures?
how can you see all indexes defined for a table? : Sql dba
How many triggers can be applied on a table?
Which is better join or inner query?
define data blocks ? : Sql dba
What are the advantages of pl sql over sql?
Is sql a dbms?
What are the different ways to optimize a sql query?
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
Enlist the advantages of sql.
explain advantages of innodb over myisam. : Sql dba
What is pl sql and why it is used for?
How to prepare for oracle pl sql certification?
Why use stored procedures?