What will happen after commit statement ?
Answers were Sorted based on User's Feedback
Answer / highness
locks will be released
changes will be made permanent
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
What is trigger in sql? Explain
Is sqlite free?
What is dml with example?
What is difference between inner join and cross join?
How do I start sql profiler?
Can any one tell me how to increase the performance of a sql query ie what are the performance tips in creating or writing a sql query !!?
explain mysql aggregate functions. : Sql dba
full outer join syntax
What is a recursive stored procedure?
what is the main difference between join and subqurey?
What is the difference between a database and a relational database?
What is the purpose of primary key?