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

use sql%rowcount after each statement

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is union and union all keyword in sql and what are their differences?

568


Explain the difference in execution of triggers and stored procedures?

561


What is the purpose of my sql?

501


What are two statement types in sql?

533


What is the command used to fetch first 5 characters of the string?

876






Does sql require a server?

521


Why do we need view in sql?

543


What is an example of translating a date into julian format?

569


What are the differences between in and exists clause?

558


What is audit logout in sql profiler?

585


Can we join two tables without common column?

507


what is the difference between nested subquery and correlated subquery?

543


Name three sql operations that perform a sort.

580


Can we use having without group by in sql?

547


What is execution plan in sql?

542