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 vote221 views1 answer
Import Data in MySQL without using any other software
SQL
0 vote208 views1 answer
Postgres data location
SQL
0 vote203 views1 answer
Pl sql constraint user function
SQL
0 vote195 views1 answer
Sql select most frequent value in group
SQL
0 vote219 views1 answer
How to delete duplicate rows in oracle
SQL
1 vote226 views1 answer
Group_concat order by
SQL
0 vote213 views1 answer
Mysql delete entire row on condition
SQL
0 vote221 views1 answer
Update having mysql
SQL
5 votes204 views3 answers
Select tables from mysql database
SQL
9 votes191 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL