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 difference between delete and truncate commands? : Sql dba

808


What is $$ in sql?

728


What is the purpose of the primary key?

754


What are sql procedures?

759


Mention what pl/sql package consists of?

724






How do we use distinct statement? What is its use?

750


what are properties of a transaction? : Sql dba

760


Why is pl sql used?

688


How can one get sql*loader to commit only at the end of the load file? : aql loader

746


How many types of triggers are there in pl sql?

781


What jobs use sql?

721


What is procedure and function in sql?

744


What are tuples in sql?

778


Explain sql data types?

830


Are there any features that are decommissioned in 11g that are not present in 11g?

1819