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

8 votes187 views2 answers
Replace string value in sql
SQL
0 vote126 views1 answer
FindAllBy
SQL
0 vote135 views1 answer
How to see the content of tables in pgadmin
SQL
4 votes195 views1 answer
Id increment ms sql server
SQL
0 vote177 views1 answer
What is between operator
SQL
3 votes207 views1 answer
Oracle undo tablespace schema
SQL
0 vote178 views1 answer
Psql list rules
SQL
15 votes178 views4 answers
How to get all tables in sql
SQL
1 vote185 views1 answer
Load sql into mamp
SQL
1 vote264 views1 answer
Connect to mysql database ubuntu
SQL