Chunked updates with savepoint per batch

Chunked updates with savepoint per batch

Hard SQL TCL 16 views
Explanation Complexity

Problem Statement

You are fixing city names in Customers in batches. Show a pattern: create savepoint, run update for a batch, rollback to savepoint if something looks wrong, else continue and finally commit.

Input Format

SQL script

Output Format

Statements

Example

Customers
Controlled update

Constraints

Pattern example

Input / Output Format

Input Format
SQL script
Output Format
Statements
Constraints
Pattern example

Examples

Input:
Customers
Output:
Controlled update

Example Solution (Public)

SQL 
BEGIN; SAVEPOINT batch1; UPDATE Customers SET city='Bengaluru' WHERE city='Banglore'; COMMIT;

Official Solution Code

BEGIN; SAVEPOINT batch1; UPDATE Customers SET city='Bengaluru' WHERE city='Banglore'; COMMIT;
Please login to submit solutions.
Editor
Output

                                        

                                    

                                    

                                        

                                                                                    
Please login to submit solutions.