oracle sql commit example

Solutions on MaxInterview for oracle sql commit example by the best coders in the world

showing results for - "oracle sql commit example"
Camila
30 Nov 2019
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