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

2 votes377 views1 answer
Oracle run_duration to number
SQL
22 votes411 views1 answer
Mysql workbench
SQL
0 vote351 views1 answer
How to update sql server version
SQL
5 votes341 views1 answer
Oracle generate list of dates in between a date range
SQL
5 votes357 views1 answer
Sql add column after another
SQL
2 votes331 views1 answer
Sql server conection string
SQL
0 vote343 views2 answers
How to type a blank discord messgae
SQL
0 vote340 views1 answer
Setval in postgres
SQL
0 vote373 views2 answers
Insert data mysql with cmd
SQL
0 vote371 views1 answer
How to connect to xampp sql server on windows cmd
SQL