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 vote263 views2 answers
Find lowest number in sql
SQL
0 vote233 views1 answer
Count number of entires by months sql
SQL
8 votes178 views1 answer
Sql remove characters from string right
SQL
0 vote205 views1 answer
Describe in sqlite3
SQL
0 vote198 views1 answer
How to connect to mysql in ef 6
SQL
0 vote193 views1 answer
Pl sql disable trigger
SQL
1 vote192 views1 answer
Psql autocomplete for mac brew install
SQL
4 votes192 views2 answers
Mysql select where starts with
SQL
5 votes247 views1 answer
Pl sql asynchronous procedure calls
SQL
0 vote218 views1 answer
Multiple like values for single column postgres
SQL