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

3 votes218 views2 answers
Oracle privileges users
SQL
2 votes159 views3 answers
Mysql pass command from command line
SQL
0 vote198 views1 answer
Mysql row generator
SQL
2 votes165 views2 answers
How to rename column name in sql server using query
SQL
6 votes201 views3 answers
Rename column ORACLE
SQL
0 vote139 views1 answer
Get who is hired in month in sql
SQL
-1 vote170 views5 answers
Convert sql to linq query online
SQL
1 vote144 views1 answer
Using SQL in rails migration
SQL
0 vote110 views1 answer
How to connect sql server using ip address in c#
SQL
1 vote167 views1 answer
Liquibase alter column type / length
SQL