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

2 votes158 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly. 11:04:35 PM [mysql] This may be due to a blocked port, missing dependencies,
SQL
5 votes157 views2 answers
Postgresql add not null constraint
SQL
1 vote86 views1 answer
Metada in sql
SQL
0 vote161 views1 answer
Mysql command line top 10
SQL
1 vote140 views1 answer
How to transfer pandas datafra,e to sqlite
SQL
0 vote169 views1 answer
Postgres docs /copy metacomand
SQL
1 vote141 views1 answer
Postgres delete from where date is greater than specific date
SQL
0 vote135 views1 answer
Contact mysql column field
SQL
4 votes136 views2 answers
Oracle unlock user
SQL
2 votes199 views1 answer
Oracle run_duration to number
SQL