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 is pivot in sql?

490


explain about mysql and its features. : Sql dba

525


How to fetch values from testtable1 that are not in testtable2 without using not keyword?

720


What is memory optimized?

524


How do I find duplicates in a single column in sql?

509






What is sequence in sql?

491


how to use in conditions? : Sql dba

484


How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

563


What are the advantages of pl sql over sql?

516


Can we use ddl statements in stored procedure sql server?

495


What is not equal in sql?

489


Explain the uses of database trigger.

624


What is sql profiling in oracle?

519


Why do we use view in sql?

510


What does partition by mean in sql?

494