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 votes104 views1 answer
Oracle apex list connected users
SQL
0 vote99 views1 answer
Mysql add to value
SQL
2 votes146 views1 answer
Tsql copy table
SQL
-1 vote104 views1 answer
Mysql order by on condition
SQL
0 vote100 views1 answer
Soql more than today
SQL
1 vote96 views1 answer
Postgresql if 0 then 1
SQL
1 vote116 views1 answer
Delete specific row in sql
SQL
0 vote103 views1 answer
Oracle string length
SQL
1 vote94 views1 answer
Pv mysql import
SQL
3 votes105 views3 answers
How to set up an auto incrementing id db browser
SQL