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 does varchar include?
how to include numeric values in sql statements? : Sql dba
What is pragma in sql?
What is the difference between python and sql?
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
differentiate between float and double. : Sql dba
Is left join faster than inner join?
What do you mean by query optimization?
what are all the common sql function? : Sql dba
What are few of the schema objects that are created using PL/SQL?
Is sql a oracle?
Can we create clustered index without primary key?
Explain the difference between 'between' & 'and' operators in sql
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
What is sql constant?