Release a savepoint (if supported)
SQL
Medium
2 views
Problem Description
Show how to release a savepoint after you are sure you will not rollback to it.
Sample Test Case
Output:
Savepoint released
Constraints
Some DBs support RELEASE SAVEPOINT
Official Solution
BEGIN; SAVEPOINT s1; UPDATE Customers SET city='Kolkata' WHERE customer_id=202; RELEASE SAVEPOINT s1; COMMIT;
Solutions (0)
No solutions submitted yet. Be the first!
No comments yet. Start the discussion!