O'Reilly logo

Oracle Database 11g PL/SQL Programming Workbook by John M. Harper, Michael McLaughlin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 3Transaction Scope

This chapter discusses the intricacies of transaction control and scope. It also demonstrates how to create PL/SQL programs that intelligently handle large volumes of database interactions. Understanding transaction control is vital for developers and DBAs who want to create stable systems that ultimately protect enterprise information from data corruption or loss. We divide this chapter into the following topics:

Image The Database ACID Test

Image Multi Version Concurrency Control (MVCC)

Savepoints, commits, and rolling back transactions ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required