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?

Answers were Sorted based on User's Feedback



While inserting/updating million of records into a database table, how do I came to know how many re..

Answer / nit

use sql%rowcount after each statement

Is This Answer Correct ?    2 Yes 0 No

While inserting/updating million of records into a database table, how do I came to know how many re..

Answer / 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

More SQL PLSQL Interview Questions

What is data control language (dcl)?

0 Answers  


What is pl sql quora?

0 Answers  


differentiate between float and double. : Sql dba

0 Answers  


How do I upgrade sql?

0 Answers  


Which are the most commonly used sql joins?

1 Answers  






explain normalization concept? : Sql dba

0 Answers  


What is column?

0 Answers  


How to connect a sql*plus session to an oracle server?

0 Answers  


Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

0 Answers  


How do you update a table in sql?

0 Answers  


Explain the the delete statements in sql?

0 Answers  


What is a record in pl/sql?

0 Answers  


Categories