What will happen after commit statement ?
- 2 Answers
- 7701 Views
- I also Faced
- E-Mail Answers
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 |
how to calculate the difference between two dates? : Sql dba
how to check server status with 'mysqladmin'? : Sql dba
How does postgresql compare to "nosql"?
How to raise user-defined exception with custom sqlerrm ?
How to select 10 records from a table?
Explain the purpose of %type and %rowtype data types?
how to insert values like 10:10:00,30:25:00 etc.into table after insert how can i sum the above insert values to get the result as 40:35:00
what is try_catch block in procedure
sales persons should always receive commission of 100 at least. employees who r not sales persons should never receive commission.(Triggers)
What are the benefits of stored procedures?
Can we call procedure in select statement?
how to calcuate the second highest salary of he employee
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
