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
Why do we use sql constraints? Which constraints we can use while creating database in sql?
What is sql select statement?
Can we rollback truncate?
write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba
What does the hierarchical profiler does?
Can you rollback after commit?
What is the difference between truncate and drop statements?
What is compiled query?
What are sql procedures?
how can you create an empty table from an existing table? : Sql dba
describe mysql connection using mysql binary. : Sql dba
What is sql indexing?
Define join and name different types of joins?
What is sqlite format?
What is cursor status?
