PL/SQL Transactions   «Prev  Next»

Lesson 6

PL/SQL Controlling Transactions Conclusion

This module covered techniques for controlling transactions within PL/SQL block. You added transaction controls to a package. You learned about locking modes and levels. You studied a special variation on the cursor declaration that allows you to lock rows immediately to prevent others from using them before your procedure can.
  1. Describe how data integrity is compromised
  2. Identify when each type of locking is used
  3. Incorporate COMMIT, ROLLBACK, and SAVEPOINT commands within PL/SQL
  4. Describe how to create explicit locks with a cursor or a table lock

By adding transaction and locking controls in your PL/SQL, you have complete control over what parts of your transactions are saved to the database and when they are saved. The next module covers another important area of control, user security.

Glossary

In this module you were introduced to the following glossary terms:
  1. Transaction control
  2. Data integrity
  3. Lock
  4. Lock level
  5. Lock mode

PL/SQL Lock Timer Quiz

Click the Quiz link below to answer a few questions about concepts and syntax for locks.
PL/SQL Lock Timer Quiz