Interested to Buy Any Domain ? << Click Here >> for more details...
What will happen after commit statement ?
- 2 Answers
- 8238 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 |
Explian rowid, rownum? What are the psoducolumns we have?
Which sorts rows in sql?
What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?
Can we join two tables without common column?
What does pl sql developer do?
Is sql similar to python?
Can we change the table name in sql?
what is the difference between delete and truncate commands? : Sql dba
What is sql constant?
What is the use of prepared statement?
I have one Excel file with 1,50,000 Records. Now I need to load that whole file into Oracle Database with same columns in Excel sheet . I need PLSQL Procedure or used by SQL PLUS
What is restrict 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)
