Oracle rollback

-- 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

13 votes380 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
0 vote383 views2 answers
SQL FROM
SQL
0 vote348 views1 answer
Oracle index hint
SQL
0 vote365 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL
15 votes352 views6 answers
Drop foreign key mysql
SQL
0 vote346 views1 answer
IIF
SQL
2 votes375 views2 answers
Install postgresql
SQL
0 vote356 views1 answer
Utiliser sql ligne de commande
SQL
0 vote388 views1 answer
Mysql multiple group by
SQL
0 vote331 views1 answer
Mysql percentage of total
SQL