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
what are sequences
Is natural join and inner join same?
how to enter characters as hex numbers? : Sql dba
Differentiate pl/sql and sql?
What is difference between inner join and self join?
What is clustered and nonclustered index in sql?
What is sql profiling in oracle?
What are the different set operators available in sql?
What are sql injection vulnerabilities?
How does rowid help in running a query faster?
Inline the values in PL/SQL, what does it mean.?
what is try_catch block in procedure
How do I create a sql script?
What are the events on which a database trigger can be based?
how to fetch common records from two tables? : Sql dba