Summary-Transactions
In this chapter, we looked at many aspects of transaction management in Oracle. Transactions are among the major features that set […]
Read More →In this chapter, we looked at many aspects of transaction management in Oracle. Transactions are among the major features that set […]
Read More →
One of the really nice features of Oracle is its ability to transparently handle distributed transactions. I can update data in […]
Read More →
You don’t need a “begin transaction” statement in Oracle. A transaction implicitly begins with the first statement that modifies data (the […]
Read More →
Many developers have some bad habits when it comes to transactions. I see this frequently with developers who have worked with […]
Read More →
We understand that the WHERE Y=5 component, the read-consistent phase of the query, will be processed using a consistent read (query […]
Read More →
So far, we’ve looked at read consistency: Oracle’s ability to use undo information to provide nonblocking query and consistent (correct) reads. […]
Read More →
In Oracle, we also have the ability to defer constraint checking, which can be quite advantageous for various operations. The one […]
Read More →
It is interesting to note exactly when integrity constraints are checked. By default, integrity constraints are checked after the entire SQL […]
Read More →
Autonomous transactions allow you to create a “transaction within a transaction” that will commit or roll back changes independently of its […]
Read More →
A common data warehousing technique I’ve seen people employ goes like this: \ 1.\ They use a trigger to maintain a […]
Read More →