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 votes169 views1 answer
Mysql time ago difference
SQL
0 vote151 views1 answer
Split a string with expression and get the last value of split sql
SQL
0 vote191 views1 answer
C# get sql min date
SQL
1 vote164 views1 answer
Mysql return text after a final full stop
SQL
0 vote161 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
1 vote272 views1 answer
Cannot define PRIMARY KEY constraint on nullable column in table 'Student'.
SQL
1 vote176 views1 answer
Copy postgres table from one schema into another
SQL
0 vote183 views1 answer
MySQL - Enabling the Event Scheduler
SQL
0 vote233 views1 answer
Oracle simple quote
SQL
0 vote177 views1 answer
How to check event scheduler status mysql
SQL