Chapter 14. Transaction Processing
Robyn Sands
After you have been using the Oracle database for a while, you might have certain expectations of how the database will behave. When you enter a query, you expect a consistent results set to be returned. If you enter a SQL statement to update several hundred records and the update of one of those rows fails, you expect the entire update to fail, and all rows to be returned to their prior state. If your update succeeds and you commit your work to the database, you expect your changes to become visible to other users and remain in the database, at least until the data is updated again by someone else. You expect that when you are reading data, you will never block a session from writing, and you also ...
Get Pro Oracle SQL now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
