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 vote220 views2 answers
Update query with between in mysql
SQL
0 vote211 views1 answer
Why mysql is used?
SQL
1 vote232 views1 answer
How to convert number to hours and minutes in oracle sql
SQL
0 vote224 views1 answer
Sql on-premises
SQL
0 vote206 views1 answer
Adding primery key constraint to a column
SQL
1 vote220 views2 answers
Login to mysql
SQL
0 vote215 views1 answer
H2 auto increment and unique
SQL
4 votes199 views1 answer
Postgresql show current database
SQL
0 vote199 views1 answer
Sql compound operators
SQL
0 vote227 views1 answer
Foreign key type uniqu mysql
SQL