After update how do u know how many records got updated

Answer Posted / mahima

use @@rowcount

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

1700


Explain the importance of .pll extension in oracle?

631


How to download oracle database 10g xe?

689


From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

701


What is a trace file and how is it created in oracle?

632






How to rename an index?

668


What is save point in oracle database?

838


What is meant by recursive hints in oracle?

714


What are the ways tablespaces can be managed and how do they differ?

1729


How can we delete duplicate rows in a table?

640


How to get the Installed Oracle Version Information ?

723


Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

1951


How do you bind variables in oracle?

639


How to do paging with oracle?

647


How to define a data source name (dsn) in odbc manager?

607