/SQL/Oracle transaction commit rollback example

Oracle transaction commit rollback example

-- 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 vote251 views3 answers
Join
SQL
0 vote242 views2 answers
Sqlalchemy core in clause
SQL
0 vote229 views1 answer
Composit key in sql
SQL
0 vote251 views1 answer
How to delete python anywhere mysql database
SQL
0 vote245 views1 answer
Sql select most frequent value in column
SQL
9 votes234 views4 answers
Last mysql
SQL
13 votes248 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
0 vote255 views1 answer
Running mysql from bash sc
SQL
0 vote269 views1 answer
Add user mysql wordpress
SQL
4 votes236 views3 answers
Copy table postgres
SQL