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 votes351 views1 answer
Oracle kill session by sql_id
SQL
27 votes357 views6 answers
Sql update record
SQL
2 votes331 views1 answer
Match in sql server
SQL
0 vote399 views1 answer
Virtuoso sql query tutorial
SQL
3 votes369 views1 answer
Postgresql if null then 0
SQL
8 votes358 views2 answers
Select table column name in sql
SQL
0 vote359 views1 answer
Add mysql database to power bi web
SQL
0 vote416 views1 answer
Différence entre deux dates sql oracle
SQL
0 vote336 views1 answer
Dns slave zone convert
SQL
0 vote341 views1 answer
Varchar format not case sensitive sql
SQL