Interested to Buy Any Domain ? << Click Here >> for more details...
What will happen after commit statement ?
- 2 Answers
- 8329 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 |
Which command is used to call a stored procedure?
Does normalization improve performance?
what are the different index configurations a table can have? : Sql dba
What is pessimistic concurrency control? : Transact sql
Which command is used to delete a package?
Why do we use cursors?
Enlist the characteristics of pl/sql?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
discuss about myisam key cache. : Sql dba
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
What is use of trigger?
Is sql a scripting language?
-
Oracle (3253) - 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)
