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
8027 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

What is pl sql in oracle?

1041

Compare sql & pl/sql

1136

What is a mutating table and a constraining table?

1114

what is the difference between inner and outer join? Explain with example. : Sql dba

1025

How many types of primary keys are there?

1036

What is restrict in sql?

1115

what is the difference between $message and $$message? : Sql dba

997

Explain two easy sql optimizations.

1008

discuss about myisam key cache. : Sql dba

1021

What is indexes?

1056

How many types of triggers exist in pl/sql?

1071

How many types of normalization are there?

959

What is a dirty read sql?

1137

What are local and global Indexes and where they are useful.

1442

Why do we need a foreign key?

1093