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 are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
How to rename a column in the output of sql query?
Can function return multiple values in sql?
what are tables and fields? : Sql dba
Differentiate pl/sql and sql?
what is oltp (online transaction processing)? : Sql dba
How much does a sql dba make? : SQL DBA
What does the sign mean in sql?
What is difference between group by and partition by?
What is memory optimized table?
What is trigger explain with example?
What is multiple columns?
How to process query result in pl/sql?
how to extract a unit value from a date and time? : Sql dba
What will you get by the cursor attribute sql%notfound?