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 vote170 views1 answer
Oracle sql procedure return value
SQL
0 vote187 views1 answer
Oracle webcenter content search enginer
SQL
17 votes188 views4 answers
Show tables sql server
SQL
4 votes172 views1 answer
Force drop all tables postgres
SQL
2 votes177 views3 answers
Sql function
SQL
0 vote178 views2 answers
Oracle select
SQL
-1 vote188 views1 answer
Sql show custom constraints
SQL
1 vote197 views3 answers
Postgresql get difference between two dates
SQL
0 vote190 views1 answer
Oracle 11g forget password
SQL
0 vote194 views1 answer
Group by 15 minute interval sql server
SQL