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

2 votes330 views2 answers
Mysql limit
SQL
0 vote312 views1 answer
Tsql cmd exec script from file
SQL
3 votes307 views1 answer
Sql select all
SQL
4 votes319 views3 answers
Oracle sql first day of quarter
SQL
14 votes336 views1 answer
Sql value of string
SQL
33 votes329 views2 answers
Postgres how to add field created at
SQL
0 vote400 views1 answer
Postgres extract number from string
SQL
0 vote312 views1 answer
Mysql group by derived column
SQL
2 votes327 views1 answer
Mysql create user with mysql_native_password
SQL
1 vote289 views1 answer
Database run
SQL