O'Reilly logo

OCA Oracle Database 11g: SQL Fundamentals I: A Real-World Certification Guide by Steve Ries

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

Transaction control

What would you say if I told you that none of the DML statements that you've executed in this chapter, INSERTs, UPDATEs, and DELETEs, actually did anything to change data in the database? As much of a surprise as it is, it is actually true. The use of DML statements comes with a caveat: they must be used in conjunction with transaction control statements.

Transactions and the ACID test

Transaction control is the act of manipulating the timing of events called transactions. In relational database theory, a transaction is a discrete unit of work within a database. Transactions allow groups of statements to be executed together, to allow for correct recovery in the event of failure. Transactions also represent data concurrency ...

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