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

what are sequences

1723


Is natural join and inner join same?

902


how to enter characters as hex numbers? : Sql dba

1025


Differentiate pl/sql and sql?

1052


What is difference between inner join and self join?

1069


What is clustered and nonclustered index in sql?

930


What is sql profiling in oracle?

1042


What are the different set operators available in sql?

1009


What are sql injection vulnerabilities?

965


How does rowid help in running a query faster?

1402


Inline the values in PL/SQL, what does it mean.?

1204


what is try_catch block in procedure

1723


How do I create a sql script?

1085


What are the events on which a database trigger can be based?

1170


how to fetch common records from two tables? : Sql dba

1155