Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What will happen after commit statement ?

Answer Posted / tulsi

The cursor having query as SELECT .... FOR UPDATE gets
closed after COMMIT/ROLLBACK.

The cursor having query as SELECT.... does not get closed
even after COMMIT/ROLLBACK

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to extract a unit value from a date and time? : Sql dba

990


What is the difference between a query and a report?

975


What is a table partition?

1132


When can we use the where clause and the having clause?

1020


What are literals in sql server?

1170


explain about mysql and its features. : Sql dba

1015


What is the difference between unique and primary key constraints?

1071


What does trigger mean in slang?

1055


How to display the records between two range in Oracle SQL Plus?

1146


How many commands are in sql?

1070


What is sqlerrm?

935


What is duration in sql profiler trace?

1079


How many parts of a pl sql block are optional?

1134


what is heap table? : Sql dba

1105


what is auto increment? : Sql dba

1008