Interested to Buy Any Domain ? << Click Here >> for more details...
What will happen after commit statement ?
- 2 Answers
- 8234 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 |
what is sql profiler
How do I view stored procedures?
What type of database is sql?
What can you do with pl sql?
What is the usage of NVL?
7 Answers Infosys, Micro Infotek,
What are the differences between implicit and explicit cursors?
What is denormalization in a database?
What is sql and how does it work?
what is heap table? : Sql dba
Explain table and field in sql?
Which one of the following join types will always create a Cartesian Product? 1. CROSS JOIN 2. LEFT OUTER JOIN 3. RIGHT OUTER JOIN 4. FULL OUTER JOIN 5. INNER JOIN
what are the demerits of sql?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
