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

0 vote268 views1 answer
How to check even or odd in sql
SQL
1 vote227 views1 answer
Postgres kill pid
SQL
25 votes277 views5 answers
Uninstall mysql ubuntu
SQL
0 vote266 views1 answer
Sql insert tuple
SQL
0 vote301 views1 answer
How to convert external table to managed table in hive
SQL
2 votes269 views1 answer
Apex execute batch job
SQL
16 votes287 views6 answers
This is incompatible with sql_mode=only_full_group_by
SQL
0 vote273 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL
0 vote292 views1 answer
Sql select sum group by id laravel join
SQL
8 votes232 views1 answer
Similarities between ddl and dml
SQL