use @@rowcount

After update how do u know how many records got updated

Question Posted / mahima

Answer Posted / mahima

use @@rowcount

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to lock and unlock a user account in oracle?

1078

How to create an initialization parameter file?

1025

What are the limitations oracle database 10g xe?

1020

How to rename a tablespace in oracle?

1069

Are truncate and delete commands same? If so why?

1128

What are the different types of modules in oracle forms?

988

What happens if the update subquery returns multiple rows?

1097

Explain compound trigger in oracle?

1017

How to start a new transaction in oracle?

1062

What is a trigger and what are its types?

1198

Give the various exception types.

972

Explain enable novalidate constraint.

1061

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2165

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

5501

What is program global area (pga) in oracle?

1011