• SAVEPOINT name —> marks a save point
• COMMIT —> making all pending changes permanent;
• ROLLBACK —> discharges all pending changes to prev commit
• ROLLBACK TO name —> rolls back changes to savepoint
/* creates a temporary memory to store values which you want
to conditionally cancel */