/SQL/Oracle transaction commit rollback example

Oracle transaction commit rollback 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

12 votes327 views1 answer
Docker mysql random root password
SQL
31 votes341 views2 answers
Grant all priviledges to mysql user
SQL
1 vote325 views1 answer
Mysql copy table1 to table2
SQL
39 votes383 views5 answers
Sql drop column
SQL
19 votes302 views1 answer
Sqrt(-1)
SQL
0 vote312 views1 answer
Oracle last character of string
SQL
0 vote298 views1 answer
Mysql select distinct date from timestamp
SQL
0 vote348 views1 answer
Mysql config address
SQL
0 vote365 views1 answer
Hashpass
SQL
0 vote329 views1 answer
Sql select where more than one record exists
SQL