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 cascade in sql?

704


What is rownum in sql?

762


What is a pragma statement?

955


what is a composite primary key ? : Sql dba

782


How do rank () and dense_rank () differ?

723






What are the different types of a subquery?

715


What is the best free sql database?

769


What is cold data?

678


What are the types pl/sql code blocks?

795


How do I get sql certification?

702


Are subqueries faster than joins?

726


Can we join 3 tables in sql?

705


What is offset in sql query?

822


What are the uses of sysdate and user keywords?

844


what is cross join? : Sql dba

742