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
7908 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 the need of a partition key?

941

What is difference sql and mysql?

939

How to read xml file in oracle pl sql?

860

What is count * in sql?

935

Explain the savepoint statement.

1038

Explain the components of sql?

993

What is foreign key and example?

886

What is partition in sql query?

947

What are properties of the transaction?

957

Is sqlite free?

907

What is sql catalog?

962

how to include comments in sql statements? : Sql dba

910

What is sql clause?

992

how to use case expression? : Sql dba

958

What is sqlerrd?

921