Nested Transactions & Savepoints

Problem

You are writing an order-processing job. Inside a transaction, you want to perform a series of operations, but if one optional step fails, you want to roll back only that step without losing all prior progress. Write a query that outputs concept with the value: "SAVEPOINT creates a named point within a transaction, allowing partial rollbacks using ROLLBACK TO SAVEPOINT."

Database Schema

This problem acts as a scratchpad. You will write your own DDL/DML or conceptual queries, so there is no predefined schema.

Try It

Hint

Solution