Murach's Oracle SQL and PL/SQL
How to manage transactions and locking

This chapter explains how Oracle manages concurrent changes to database data in a multi-user environment and shows how you, as a developer, can use transactions and locking to prevent data errors.
Chapter 14 How to manage transactions and locking
How to work with transactions 448
How to commit and rollback transactions 448
How to work with save points 450
How to work with concurrency and locking 452
How concurrency and locking are related 452
The four concurrency problems that locks can prevent 454
How to set the transaction isolation level 456
How to prevent deadlocks 458


© Copyright 1998-2009 Mike Murach & Associates, Inc.  All rights reserved.

Murach's Oracle SQL and PL/SQL

Learn more about this book

View the table of contents

Add this book to your cart



Our Ironclad Guarantee

First, try our books for 90 days. Then, if you aren't completely convinced that our books are the best ones you've ever used, you can return them for a full refund...no questions asked.