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 →It is the function of the RECO background process to resolve this issue. This is also where COMMIT and ROLLBACK with […]
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 →The most serious problem with the “commit before the logical transaction is over” approach is the fact that it frequently leaves […]
Read More →Let’s now look at the second reason developers are tempted to commit updates in a procedural loop, which arises from their […]
Read More →It is interesting to note that Oracle considers PL/SQL blocks to be statements as well.Consider the following stored procedure and reset […]
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 →In this chapter, we covered a lot of material that, at times, might not have been obvious. However, it is vital […]
Read More →The first thing that pops out should be “Our trigger fired twice!” We had a one-row table with a BEFORE FOR […]
Read More →Consider the following statement:SQL> Insert into t values ( 1 ); It seems fairly clear that if the statement were to […]
Read More →