Interested to Buy Any Domain ? << Click Here >> for more details...
What will happen after commit statement ?
- 2 Answers
- 8132 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 are synonyms in sql?
What is bulk collections?
Can you skip header records while loading? : aql loader
how to eliminate null values in a column i.e table vlaues 1 2 3 NULL 3 4 1 5 NULL i want output like this 1 2 3 3 4 1 5 i dnt want to use nvl is null and i dnt want replace the NULL value with any value i.e nvl(col,o);
What are different clauses used in sql?
How do you create a db file?
Can we insert delete data in view?
Name the different types of indexes in sql and define them.
what is inline view?
How do I view a view in sql?
What do you mean by query optimization?
Table Student has 3 columns,Student_id,Student_Name & Course_Id. Table Course has 2 columns, Course_Id & Course_Name.Write a query to listdown all the Courses and number of student in each course.
-
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)
