Oracle sql commit example

-- Rollback (cancellation)
DELETE FROM employees WHERE employee_id = 123;    -- Done in current session
ROLLBACK;                                         -- Cancelled in current session
SELECT * FROM employees WHERE employee_id = 123;  -- Found
-- Commit (validation)
DELETE FROM employees WHERE employee_id = 123;    -- Done in current session
COMMIT;                                           -- Visible for ALL sessions
SELECT * FROM employees WHERE employee_id = 123;  -- Missing for ALL sessions

Source: oracle-dba-online.com

Similar codes

0 vote117 views1 answer
Custom row number
SQL
5 votes115 views2 answers
Postgresql insert select
SQL
0 vote113 views1 answer
Reset keys in sql
SQL
2 votes130 views1 answer
Mysql now format
SQL
13 votes114 views1 answer
Sql join 3 tables on id
SQL
10 votes90 views3 answers
Join multiple tables sql
SQL
0 vote119 views1 answer
Postgres foreign key multiple columns
SQL
2 votes97 views1 answer
Match in sql server
SQL
0 vote112 views1 answer
Window function to forward fill
SQL
0 vote119 views2 answers
Oracle ora-00054 how to unlock
SQL