use sql%rowcount after each statement

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?

Question Posted / nit

2 Answers
8124 Views
HSBC, I also Faced
E-Mail Answers

Answer Posted / nit

use sql%rowcount after each statement

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

2062

What is a ddl command?

1154

How do I view tables in mysql?

1027

what is log shipping? : Sql dba

1165

Which is faster union or join?

1024

What is update query?

1031

What is difference between joins and union?

1194

how to drop an existing view in mysql? : Sql dba

1104

What is sqlservr exe?

1028

explain the advantages and disadvantages of stored procedure? : Sql dba

1062

Name the different types of indexes in sql and define them.

1222

Why stored procedure is better than query?

1000

what are tables and fields? : Sql dba

1103

Does varchar need length?

1048

What is the need of a partition key?

1028