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
Can we delete column in sql?
What are the types of keys?
Why use stored procedures?
What is set serveroutput on?
what is sp_pkeys? : Transact sql
Which join is like an inner join?
What is a stored procedure in sql with example?
What is the difference between pl and sql?
what are myisam tables? : Sql dba
What is a clob in sql?
define data blocks ? : Sql dba
What is the use of function in sql?
What is the difference between subquery and correlated query?
Why do we need pl sql?
What does where 1/2 mean in sql?
