/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

1 vote277 views2 answers
Postgresql remote connect
SQL
1 vote269 views1 answer
Postgresql transaction discard all
SQL
1 vote285 views2 answers
One to one and one to many relationship
SQL
9 votes301 views3 answers
Sql delete where in
SQL
0 vote278 views1 answer
Setval in postgres
SQL
0 vote261 views1 answer
Find most frequent value in SQL column
SQL
1 vote245 views1 answer
Delete triger pl pg sql
SQL
0 vote302 views2 answers
How to drop mili second in sql
SQL
0 vote278 views1 answer
Connect to nginx server mysql remotly
SQL
0 vote262 views1 answer
Dnsmasq.conf location macos
SQL