/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

6 votes283 views2 answers
How to get yesterday date in mysql
SQL
0 vote261 views1 answer
Narural join
SQL
6 votes286 views3 answers
Mysql remove user privileges
SQL
12 votes264 views6 answers
Select distinct
SQL
0 vote275 views1 answer
Get sum sqlite android
SQL
0 vote262 views2 answers
The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue.
SQL
0 vote275 views1 answer
SQL SELECT TOP Equivalent in MySQL
SQL
14 votes275 views4 answers
Online sql compiler
SQL
4 votes269 views1 answer
List tables sqlite
SQL
1 vote268 views1 answer
Alter constraint postgres
SQL