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 the use of double ampersand (&&) in sql queries?
What is a sql driver?
What is trigger in pl sql?
how can create data base link for tow servers (scott schema) give examples plz
How do you get column names only for a table (sql server)?
What is the difference between left outer join and left join?
Can you create a table with Primary Key not as the clustered index.
Is mariadb nosql?
Advantages and disadvantages of stored procedure?
What are the two types of exceptions in pl/sql?
what is the difference between to_char and to_date functions?
explain the delete statements in 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)