oracle rollback

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

we are a community of more than 2 million smartest coders
registration for
employee referral programs
are now open
get referred to google, amazon, flipkart and more
register now
  
pinned-register now
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