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 vote314 views1 answer
Table or view does not exist
SQL
0 vote304 views7 answers
Les jointures sql server
SQL
0 vote289 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote315 views1 answer
How to add unique key constraint in mysql
SQL
0 vote302 views1 answer
What is default mysql database password in linux
SQL
3 votes305 views2 answers
Brew start mysql
SQL
0 vote338 views1 answer
Cartesian product sql
SQL
-1 vote292 views1 answer
MySQL said: Documentation #1010 - Error dropping database errno: 39 "Directory not empty")
SQL
4 votes308 views2 answers
Select first and last row mysql
SQL
2 votes341 views1 answer
Create mysql user on all hosts
SQL