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

can use the following like overloading concept in a single package: procedure p1(a varchar), procedure p1(a varchar2), procedure p1(a char)

5 Answers  


Why we use sql profiler?

0 Answers  


how to include character strings in sql statements? : Sql dba

0 Answers  


Explain correlated query work?

0 Answers  


What is rank () in sql?

0 Answers  






Why do we need view in sql?

0 Answers  


What are the different dcl commands in sql?

0 Answers  


What are character functions in sql?

0 Answers  


What is sap sql anywhere?

0 Answers  


What is attribute indicator in pl sql?

0 Answers  


What is pseudo column ?

6 Answers   ABB,


What is the use of primary key?

0 Answers  


Categories