Interested to Buy Any Domain ? << Click Here >> for more details...
What will happen after commit statement ?
- 2 Answers
- 8249 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 |
Explain what is an index?
What are different types of refreshment techniques of materialised view
What are data types in pl sql?
How to assign sql query results to pl sql variables?
how to convert character strings to numeric values? : Sql dba
Which is faster union or join?
can i use global variables in stored procedure or function
i have a customer table. trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output. trans_id trans_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id.
Can you do multiple joins in sql?
How many sql statements are used?
What does the file extension accdb stand for?
what is offset-fetch filter in tsql? : Transact 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)
