oracle rollback

Solutions on MaxInterview for oracle rollback by the best coders in the world

showing results for - "oracle rollback"
Elio
18 Nov 2020
1-- Rollback (cancellation)
2DELETE FROM employees WHERE employee_id = 123;    -- Done in current session
3ROLLBACK;                                         -- Cancelled in current session
4SELECT * FROM employees WHERE employee_id = 123;  -- Found
5-- Commit (validation)
6DELETE FROM employees WHERE employee_id = 123;    -- Done in current session
7COMMIT;                                           -- Visible for ALL sessions
8SELECT * FROM employees WHERE employee_id = 123;  -- Missing for ALL sessions