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?
Answers were Sorted based on User's Feedback
Answer / hairreddy
by using cursor attribute cursorname%rowcount we can find how many records fetched
Is This Answer Correct ? | 0 Yes | 0 No |
can use the following like overloading concept in a single package: procedure p1(a varchar), procedure p1(a varchar2), procedure p1(a char)
Why we use sql profiler?
how to include character strings in sql statements? : Sql dba
Explain correlated query work?
What is rank () in sql?
Why do we need view in sql?
What are the different dcl commands in sql?
What are character functions in sql?
What is sap sql anywhere?
What is attribute indicator in pl sql?
What is pseudo column ?
What is the use of primary key?