What you’ll learn in this Chapter
✓ What is a transaction in Oracle and PostgreSQL
✓ How to end a transaction
✓ What kind of SQL statements can be part of a transaction
✓ Transaction timeout
Overview
Transaction in database terminology is an atomic unit of work that contains one or more SQL statements.
In this chapter, we explain you how transaction in PostgreSQL varies from Oracle database. Which SQL statements can be part of a transaction and what is their effect during the transaction.