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


Please Help Members By Posting Answers For Below Questions

what is the difference between blob and text? : Sql dba

619


How exception is different from error?

646


What types of commands can be executed in sql*plus?

644


What is a record in a database?

655


Explain the difference between cursor declared in procedures and cursors declared in the package specification?

667






Can triggers stop a dml statement from executing on a table?

697


What is a database trigger?

698


What are the advantages of normalization?

656


How do you know if a relationship is 2nf?

601


How do sql databases work?

620


Write a query to find the names of users that begin with "um" in sql?

595


How can we make an if statement within a select statement?

617


What is difference between rank () row_number () and dense_rank () in sql?

678


How do I create an index in word?

624


What are the usages of sql?

659