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 nosql example?
what are the differences between char and nchar? : Sql dba
What does fetching a cursor do?
What is the difference among union, minus and intersect?
How many sql statements are used?
How to process query result in pl/sql?
What are inner and outer joins examples of both?
What is a clob in sql?
How do you use a while loop in pl sql?
What is full join?
what are the type of locks ? : Sql dba
what is the difference between a having clause and a where clause? : Sql dba
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
What does over partition by mean in sql?
Explain exception handling in pl/sql?