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
What is cascade in sql?
What is rownum in sql?
What is a pragma statement?
what is a composite primary key ? : Sql dba
How do rank () and dense_rank () differ?
What are the different types of a subquery?
What is the best free sql database?
What is cold data?
What are the types pl/sql code blocks?
How do I get sql certification?
Are subqueries faster than joins?
Can we join 3 tables in sql?
What is offset in sql query?
What are the uses of sysdate and user keywords?
what is cross join? : Sql dba