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 a local and a global temporary table? : Sql dba

547


Explain ddl statements in pl/sql?

570


What is input buffer in sql*plus?

632


How many types of index are there?

541


Write a query to display the current date in sql?

505






What is difference between mysql and postgresql?

506


Does sql full backup truncate logs?

523


How can you save or place your msg in a table?

517


What are the benefits of pl sql?

519


What is data manipulation language?

688


How do I enable sql encryption?

516


What is %type in sql?

509


What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

526


What is a field in a database?

566


What happens when a trigger is associated to a view?

494