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
how to extract a unit value from a date and time? : Sql dba
What is the difference between a query and a report?
What is a table partition?
When can we use the where clause and the having clause?
What are literals in sql server?
explain about mysql and its features. : Sql dba
What is the difference between unique and primary key constraints?
What does trigger mean in slang?
How to display the records between two range in Oracle SQL Plus?
How many commands are in sql?
What is sqlerrm?
What is duration in sql profiler trace?
How many parts of a pl sql block are optional?
what is heap table? : Sql dba
what is auto increment? : Sql dba